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

246 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
migrates11111285(None) 
emigrates1248581emigrates
migrate101314171migrate_
migrated121110511migrated
misrates101318241misrates
amirates101114792ami_rates
citrates102315092citrates
disrates91118152disrates
emigrate1149602emigrate_
emigrated1347072emigrated
emirates101214852emi_rates
grates75429892__grates
immigrates1544022immigrates
ingrates9514172ingrates
librates103412952librates
ligates82318382lig_ates
magnates11511612magnates
migraines1286932migraines
migrants1138182migrants
migrator1147872migrator
migrators1247542migrators
mirages102213532mi_rages
misdates111113632misdates
misgrades1347362misgrades
mismates121114562mismates
misrate91319142misrate_
misrated111315382misrated
nitrates82516222nitrates
picrates122013212picrates
pirates93020332pi_rates
regrates92618402regrates
remigrates1348582remigrates
titrates82314662titrates
vibrates132210612vibrates
virgates1237922virgates
acierates11310813acierates
aerates74627493_aerates
agates76121343_ag_ates
aggrades1135863aggrades
agitates9310883agitates
agnates82813193_agnates
agrafes1137523_agrafes
aigrets82810533aigret_s
aigrettes1046393aigrettes
airdates939723airdates
ameerates1149063ameerates
amirate91115953ami_rate_
berates94126873_berates
bigarades1344143bigarades
borates94823013_borates
carates95630613_carates
cerates95428253_cerates
cigarets1145473cigarets
ciliates10413453ciliates
cirrate92413493cirrate_
citrate92216803citrate_
citrated112712253citrated
cognates11311583cognates
crates85736063__crates
curates95323833_curates
degrades11269923degrades
denigrates1298113denigrates
derates84028893_derates
dictates11311383dictates
digraphs15105753digraphs
dilates83220663di_lates
diorites9313523diorites
disgraces1348453disgraces
disrate81418523disrate_
disrated10915573disrated
emeerates1149373emeerates
emigrants1244733emigrants
emigres1037673emigr__es
emirate91015833emi_rate_
engraves1237233engraves
ergates8314493erg_ates
ferrates113013423ferrates
figeater1236953figeater
figeaters1345753figeaters
figurate1237193figurate_
filiates11412663filiates
filtrates1247733filtrates
fixates1737393fi_xates
frigates12310933frig_ates
fumigates1545573fumig_ates
gates65939513__g_ates
graces94523493__graces
grades84926313__grades
grapes95123123__grapes
grate64932883__grate_
grated84523923__grated
grater74625443__grater
graters85419743__graters
gratis74819243__gratis
graves104624003__graves
grazes164519643__grazes
gyrates113610263_gyrates
hydrates15229413hydrates
ideates8313733_ideates
ignites81310583_ignites
imamates1237663imamates
imbrutes1244203imbrutes
imitates10310503imitates
immigrate1444353immigrate_
immigrated1643313immigrated
ingates82716913_ingates
ingrate8715123ingrate_
inmates92715783_inmates
iodates8312903_iodates
irades74517393_i_rades
irate55627983_i_rate_
irater65218353_i_rater
iratest7312483_i_ratest
iterates81317823iterates
karates115617473_karates
legates82917683leg_ates
liberates111012943liberates
librate93214233librate_
librated113110313librated
ligases82310713lig_ases
ligate72519253lig_ate_
ligated92414143lig_ated
lignites9129613lignites
liquates1737453liquates
literates91415653literates
macerates132113573macerates
macrames1438953macrames
madrases112610003madrases
magnate10512703magnate_
malates93522603m_alates
maleates103316343maleates
mandates11314093mandates
margraves1544833margraves
mates75251363m___ates
maturates11311763maturates
mediates112814063mediates
meliorates1288903meliorates
metates92720013m_etates
microbes1439403microbes
micturates1456093micturates
midranges1344653midranges
miggles113512033mig_gles
mights123516253mig_ht_s
migraine1157863migraine
migrant10314313migra_nt
migrating13910533migrating
migration12179703migration
migrations13168683migrations
migratory1545343migratory
mihrabs1444203mihra_bs
milages103114403mi_lages
mileages11249693mileages
militates11310883militates
millages113212903millages
millraces1345753millraces
minarets1048843minarets
mintages111110513mintages
minutes93513443mi_nutes
miracles1238333mi_racles
mirage92313653mi_rage_
mires75640883mi_r__es
mirexes1636993mi_rexes
mirths114912993mi_r_ths
misate81222693mi_sate_
miscites12313783miscites
miscreates1448103miscreates
misdate101413963misdate_
misdated121211123misdated
miseases102614343miseases
miseaten10310773miseaten
miseats92815783miseat_s
misframes1646633misframes
misgrade1247503misgrade_
misgraded1446233misgraded
misgrafted1743793misgrafted
misgrafts1544293misgrafts
mismakes16129883mismakes
mismate111415353mismate_
mismated131111333mismated
misnames12119883misnames
mispages13311183mispages
misraise10410523misraise
misraises1149933misraises
misrelates1247623misrelates
misroutes1148313misroutes
misrules1039383misrules
misstates11710633misstates
mistakes141213413mistakes
mistraces13312293mistraces
miswrites1447983miswrites
mites75141803mi___tes
mitigates1248253mitigates
mitres83922073mitr__es
moderates12710753moderates
moorages1139053moorages
morales93619403m_orales
muriates10312083muriates
mutates92215793m_utates
narrates8312763narrates
negates83215843neg_ates
nictates1039593nictates
nidates8311893ni_dates
niobates1037283niobates
nitrate72017013nitrate_
nitrated92213153nitrated
nitrites82313453nitrites
operates10515413operates
orates64328613__orates
outrates82421373outrates
phorates13413043phorates
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pirate82322883pi_rate_
pirated102515613pi_rated
prates84633163__prates
priorates11410763priorates
prorates10418073prorates
rates55352013___rates
recrates102420373recrates
regrades103212173regrades
regrate82618663regrate_
regrated102816333regrated
remigrate1249223remigrate_
remigrated1447493remigrated
serrates82617023serrates
sigmate10710143sigmate_
signages1037483signages
sinuates8310963sinuates
situates8310373situates
tirades8311723ti_rades
titrate72215573titrate_
titrated92611683titrated
uncrates10314563uncrates
upgrades12216063upgrades
uprates93814863_uprates
urates65027763__urates
vibrate122811523vibrate_
vibrated14228393vibrated
vibratos13217483vibratos
vicarates1487623vicarates
violates11311193violates
virgate1138733virgate_
vitiates112311433vitiates
vizirates2144663vizirates
zincates1937743zincates

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 Limit1461622467.12320519.7
3Display Results2462460.1102236.4
 (SQL Overall)1786912467.65623340.0
 
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.