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 “militates” 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.

117 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
militates1131088(None) 
militate10311671militate_
militated1248801militated
ciliates10413452cili_ates
filiates11412662fili_ates
imitates10310502_imitates
meditates1239812meditates
militances1445682militances
militants1146712militants
militaries1249442militaries
ministates1246742ministates
misstates11710632misstates
mitigates1248252mitigates
silicates11311522silicates
agitates9310883_agitates
califates14310113califates
cavitates14168963cavitates
celibates1358633celibates
ciliate9514603cili_ate_
ciliated11510953cili_ated
climates12311973_climates
cogitates1247863cogitates
debilitates1444473debilitates
delicates12314313delicates
dictates11311383di_ctates
digitate1098683digitate_
digitated1286963digitated
dilatate947773dilatate_
dilates83220663dil__ates
facilitates1644303facilitates
filiate10414233fili_ate_
filiated12610083fili_ated
filtrates1247733filtrates
foliates11412753foli_ates
habilitates1673583habilitates
hesitates1269793hesitates
humiliates1544623humili_ates
imitate9310873_imitate_
imitated1138263_imitated
implicates1646783implicates
initiates9411183_initiates
instates81615833_instates
irritates977223irritates
kalifates1646133kalifates
levitates1247863levitates
ligates82318383__ligates
litigates1048003litigates
litotes7311183__litotes
malates93522613mal__ates
maleates103316343mal_eates
maltases1039693mal_tases
marinates112516383marinates
mediates112814063medi_ates
medicates14312113medicates
meditate11310623meditate_
meditated1348083meditated
melilites1149193melilites
melinites11310413melinites
meliorates1288913meliorates
meltages1148243mel_tages
metates92720013m__etates
migrates111112853mi_grates
milages103114403mil__ages
mileages11249693mil_eages
militance1346123militance
militancies1554223militancies
militancy1644133militancy
militant10411403milita_nt
militantly1553723militantly
militantness1451903militantness
militaria1147213militaria
militarise1286863militarise
militarises1366503militarises
militarism1486783militarism
militarist1278913militarist
militarizes2245933militarizes
military1347233milita_ry
militating1348823militating
militiamen1462163militiamen
militias1048633milit_ias
millages113212903mil_lages
millcakes1744683millcakes
milliares1149403milliares
milliwatts1552743milliwatts
millraces1345753millraces
mimetites1346823mimetites
minimaxes2043943minimaxes
ministate1147263ministate_
mintages111110513mi_ntages
misdates111113633mi_sdates
mislocates14107223mislocates
mismates121114563mi_smates
misrates101318243mi_srates
misstate10711343misstate_
misstated1278973misstated
mistakes141213413mi_stakes
mitigate1148693mitigate_
mitigated1347083mitigated
motivates1447073motivates
muriates10312083muri_ates
mutates92215793m__utates
mutilates11310953mutilates
nictates1039593ni_ctates
nictitates1244953nictitates
obligates12207853obligates
palmitates1445453palmitates
palpitates1445303palpitates
pilotages1245503pilotages
salivates1239293salivates
sanitates9611733sanitates
sibilates1148443sibilates
silicate10312623silicate_
titivates1246433titivates
validates1338243validates
veritates12310973veritates
vitiates112311433viti_ates
vizirates2144663vizirates

Search took 9 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411177.72019254.0
3Display Results1171170.0601950.0
 (SQL Overall)1786911178.21621749.1
 
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.