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 “militate” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 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
militate1031167(None) 
militated1248801militated
militates11310881militates
ciliate9514602cili_ate
digitate1098682digitate
dilatate947772dilatate
filiate10414232fili_ate
imitate9310872_imitate
meditate11310622meditate
militance1346112militance
militant10411402militant
militants1146712militants
military1347232military
ministate1147262ministate
misstate10711342misstate
mitigate1148692mitigate
silicate10312622silicate
agitate8312063_agitate
bilobate1247033bilobate
bistate9313823bi_state
califate13310483califate
capitate121712183capitate
cavitate13159833cavitate
celibate1259313celibate
ciliated11510953cili_ated
ciliates10413453cili_ates
ciliolate1145973ciliolate
climate11312833_climate
cogitate1148553cogitate
debilitate1344863debilitate
delicate11315493delicate
dictate10311663di_ctate
digitated1286963digitated
dilate73220693dil__ate
facilitate1544573facilitate
filiated12610083fili_ated
filiates11412663fili_ates
filtrate1148223filtrate
foliate10513533foli_ate
habilitate1573803habilitate
hesitate1169973hesitate
humiliate1444973humili_ate
imitated1138263_imitated
imitates10310503_imitates
implicate1547273implicate
initiate8412693_initiate
instate71616483_instate
irritate867873irritate
kalifate1556493kalifate
levitate1137933levitate
ligate72519253__ligate
litigate948303litigate
malate84624563mal__ate
maleate94117543mal_eate
maltase938903mal_tase
marinate103017783marinate
mediate103415213medi_ate
medicate13513243medicate
meditated1348083meditated
meditates1239813meditates
melilite10410573melilite
melinite10411753melinite
meliorate1179483meliorate
meltage1037953mel_tage
metate82720533m__etate
migrate101314173mi_grate
milage93414123mil__age
mileage10299313mil_eage
milia72719573mili_a__
miliary1249463mili_ary
militances1445683militances
militancy1644123militancy
militantly1553723militantly
militaria1147213militaria
militaries1249443militaries
militarise1286863militarise
militarize2155783militarize
militating1348823militating
militia949733milit_ia
militiamen1462163militiamen
militias1048633militias
millage103112753mil_lage
millcake1644653millcake
milliare1039153milliare
milliwatt1444773milliwatt
millrace1245433millrace
mimetite1247603mimetite
ministates1246743ministates
mintage101110123mi_ntage
misate81222693m__isate
misdate101413963mi_sdate
mislocate13107713mislocate
mismate111415353mi_smate
misrate91319143mi_srate
misstated1278973misstated
misstates11710633misstates
mistake131312623mi_stake
mitigated1347083mitigated
mitigates1248253mitigates
motivate1347693motivate
multiage1147983multiage
multistate1245513multistate
muriate9313363muri_ate
muricate12311113muricate
mutate83017483m__utate
mutilate10312273mutilate
nictate9310223ni_ctate
nictitate1145403nictitate
obligate11198303obligate
palmitate1346413palmitate
palpitate1365973palpitate
peltate92013773pel_tate
pileate93815923pil_eate
pilotage1145373pilotage
plicate11314513_plicate
salivate11310013salivate
sanitate8612043sanitate
sibilate1049533sibilate
silicates11311523silicates
stipitate1144613stipitate
titivate1146803titivate
umbilicate1653043umbilicate
validate1239003validate
vitiate103412953viti_ate
vittate10409733vi_ttate
vizirate2045353vizirate

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.423422437.4
2DLD Change Limit1461621267.42019698.4
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.88922650.7
 
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.