Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “militant” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

61 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
militant1041140(None) 
militants1146711militants
dilatant948202dilatant
militance1346112militance
militancy1644122militancy
militantly1553722militantly
military1347232military
militate10311672militate
visitant1147362visitant
volitant1147862volitant
blatant9310673_blatant
dilatants1044513dilatants
diligent1048033diligent
distant83519953di_stant
equitant1746923equitant
excitant1777353excitant
galivant1247083galivant
habitant1348673habitant
hesitant1149083hesitant
incitant10810083incitant
instant7815353_instant
irritant847693irritant
litany939053__litany
litigant946873litigant
malignant1245223malignant
mediant103516703medi_ant
medicant13910833medicant
migrant10314313mi_grant
milia72719573mili_a__
miliary1249463mili_ary
militances1445683militances
militaria1147213militaria
militarist1278913militarist
militated1248803militated
militates11310883militates
militating1348823militating
militia949733milit_ia
militias1048633militias
milkman1544913milkman_
milliwatt1444773milliwatt
miltiest103015173miltiest
milting103619123mil_ting
ministrant1255813ministrant
minivan1245713minivan_
minivans1345413minivans
mirliton1044183mirliton_
mirlitons1144113mirlitons
misplant12410763misplant
misstart10410043misstart
mutant8317693m__utant
nictitant1154393nictitant
nonmilitant1354783nonmilitant
oscitant1046903oscitant
palpitant1345313palpitant
pliant83918823_pli_ant
reliant7319243reli_ant
saltant7316773sal_tant
sibilant10158273sibilant
valiant10314623vali_ant
vigilant1246423vigilant
visitants1244763visitants

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.406440125.6
2DLD Change Limit146162617.06320694.0
3Display Results61610.0302033.3
 (SQL Overall)178691617.49923828.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.