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

279 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
migrate10131417(None) 
emigrate1149601emigrate
migrated121110511migrated
migrates111112851migrates
misrate91319141misrate
amirate91115952ami_rate
cirrate92413492cirrate
citrate92216802citrate
disrate81418522disrate
emigrated1347072emigrated
emigrates1248582emigrates
emirate91015832emi_rate
figurate1237192figurate
grate64932882__grate
immigrate1444352immigrate
ingrate8715122ingrate
irate55627982_i_rate
librate93214232librate
ligate72519252lig_ate
magnate10512702magnate
migraine1157862migraine
migrant10314312migrant
migrants1138182migrants
migrator1147872migrator
mirage92313652mi_rage
misate81222692mi_sate
misdate101413962misdate
misgrade1247502misgrade
mismate111415352mismate
misrated111315382misrated
misrates101318242misrates
nitrate72017012nitrate
picrate112014142picrate
pirate82322882pi_rate
regrate82618662regrate
remigrate1249222remigrate
sigmate10710142sigmate
titrate72215572titrate
vibrate122811522vibrate
virgate1138732virgate
acerate92818913acerate
acierate10311813acierate
aerate64830553_aerate
agate66525153_ag_ate
aggrade1035643aggrade
agitate8312063agitate
agnate73314883_agnate
agrafe1038093_agrafe
aigret73720023aigret_
aigrets82810533aigrets
aigrette946833aigrette
airdate8311323airdate
ameerate1039633ameerate
amirates101114793ami_rates
aurate64426473_aurate
berate84729023_berate
biforate1346903biforate
bigarade1244763bigarade
binate8419773bi_nate
bistate9313823bistate
borate85026153_borate
carate84734003_carate
cerate84829463_cerate
cigaret10413003cigaret
ciliate9514603ciliate
citrated112712253citrated
citrates102315093citrates
cognate10312203cognate
crate76537403__crate
curate85226243_curate
degrade10229903degrade
denigrate1168693denigrate
derate74531233_derate
dictate10311663dictate
digerati1047403digerati
digitate1098683digitate
digraph14146643digraph
dilate73220693di_late
diorite8314913diorite
disgrace1248283disgrace
disrated10915573disrated
disrates91118153disrates
emeerate10410103emeerate
emigrant1148553emigrant
emigrants1244733emigrants
emigre937053emigr__e
emirates101214853emi_rates
engrave1137133engrave
ergate7315143erg_ate
ferrate103014043ferrate
figeater1236953figeater
filiate10414233filiate
filtrate1148223filtrate
fissate103010033fissate
fixate1638733fi_xate
frigate11311063frig_ate
fumigate1446153fumig_ate
gate55746573__g_ate
grace85124543__grace
grade75126093__grade
grape84824663__grape
grat55651283__grat_
grated84523923__grated
grater74625443__grater
grates75429893__grates
grave94624873__grave
graze155820053__graze
gyrate104912523_gyrate
hydrate14239813hydrate
ideate7313683_ideate
ignite71410583_ignite
imamate1138103imamate
imbrute1144913imbrute
imitate9310873imitate
immigrated1643313immigrated
immigrates1544023immigrates
ingate73018243_ingate
ingrates9514173ingrates
inmate82917363_inmate
innate63917313_innate
iodate7313503_iodate
irade65618153_i_rade
irater65218353_i_rater
iterate71119113iterate
jugate14379463jug_ate
karate105320923_karate
legate72917453leg_ate
liberate101113383liberate
librae84310173libra_e
librated113110313librated
librates103412953librates
ligase7259913lig_ase
ligated92414143lig_ated
ligates82318383lig_ates
lignite81310303lignite
ligulate92510253ligulate
limbate1139213limbate
lineate7815153lineate
liquate1638423liquate
literate81216893literate
lyrate94112103_lyrate
macerate122314073macerate
macrame1338713macrame
magmata1237463magmata
magnates11511613magnates
maigre9309163maigr__e
malate84624553m_alate
maleate94117543maleate
mammate104411273mammate
mandate10315573mandate
margrave1444793margrave
mate65154223m___ate
maturate10312613maturate
mediate103415213mediate
meliorate1179483meliorate
metate82720533m_etate
micra96214973micra__
microbe1338663microbe
micturate1366643micturate
midrange1244433midrange
midrash1335423midrash
miggle104012113mig_gle
might113827083mig_ht_
mights123516253mig_hts
mighty154310203mig_hty
migraines1286933migraines
migrating13910533migrating
migration12179703migration
migrators1247543migrators
migratory1545343migratory
mihrab1335523mihra_b
mihrabs1444203mihrabs
mikra114610313mikra__
milage93414123mi_lage
mileage10299313mileage
militate10311673militate
millage103112753millage
millrace1245433millrace
minae75627723mi_na_e
minaret9520683minaret
mintage101110123mintage
minute83414293mi_nute
miracle1138843mi_racle
mirages102213533mi_rages
mire66748233mi_r__e
mirth106418893mi_r_th
miscite11314383miscite
miscreate1348893miscreate
misdated121211123misdated
misdates111113633misdates
misease92713043misease
miseat82925703miseat_
miseaten10310773miseaten
miseats92815783miseats
misframe1546973misframe
misgave13298283misgave
misgraded1446233misgraded
misgrades1347363misgrades
misgraft1447193misgraft
misgrafted1743793misgrafted
misgrafts1544283misgrafts
mismade12129353mismade
mismake15139373mismake
mismated131111333mismated
mismates121114563mismates
misname11119483misname
mispage12310523mispage
misraise10410523misraise
misrelate1147933misrelate
misroute1049103misroute
misrule939353misrule
misstate10711343misstate
mistake131312623mistake
mistrace12312643mistrace
miswrite1348923miswrite
miswrote1346183miswrote
mite66249413mi___te
mitigate1148693mitigate
mitral81314323mitra_l
mitre75522423mitr__e
moderate11710993moderate
moorage1038743moorage
morae75831193m_ora_e
morale85220553m_orale
muriate9313363muriate
mutate83017483m_utate
narrate7313493narrate
negate72915573neg_ate
nictate9310223nictate
nidate7313783ni_date
niobate937703niobate
nitrated92213153nitrated
nitrates82516223nitrates
nitrite72314463nitrite
operate9615733operate
orate55133303__orate
outrate72323183outrate
overate10620963overate
phorate12413363phorate
picrated132110113picrated
picrates122013213picrates
picrite111911313picrite
pileate93815923pileate
pinnate93613743pinnate
pirated102515613pi_rated
pirates93020333pi_rates
prate75135983__prate
priorate10411733priorate
prorate9418733prorate
rate45458763___rate
recrate92621663recrate
regrade92612033regrade
regrated102816333regrated
regrates92618403regrates
remigrated1447493remigrated
remigrates1348583remigrates
rugate75813813rug_ate
serrate73017543serrate
signage937773signage
sinuate7412163sinuate
situate7410783situate
tirade7311693ti_rade
titrated92611683titrated
titrates82314663titrates
togate74515683tog_ate
uncrate9415953uncrate
upgrade11215823upgrade
uprate83916543_uprate
urate55432163__urate
vibrated14228393vibrated
vibrates132210613vibrates
vibrato12247383vibrato
vicarate1378603vicarate
violate10311553violate
virgates1237923virgates
vitiate103412953vitiate
vittate10409733vittate
vizirate2045353vizirate
zincate1838533zincate

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 Filter1786911340270.906197230.7
2DLD Change Limit1340272797.00019146.7
3Display Results2792790.0933000.0
 (SQL Overall)1786912797.99922339.2
 
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.