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

240 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
emirates10121485(None) 
amirates101114791amirates
emigrates1248581emigrates
emirate91015831emirate_
amirate91115952amirate_
emanates10311332emanates
embraces14128872embraces
embrutes1245192embrutes
emeerates1149372emeerates
emigrate1149602emigrate_
emigrated1347072emigrated
emulates10312572emulates
epilates10313502epilates
geminates12310042geminates
imitates10310502imitates
levirates1247492levirates
migrates111112852_migrates
mirages102213532_mirages
misrates101318242_misrates
pirates93020332_pirates
remigrates1348582remigrates
acierates11310813acierates
aerates74627493_aerates
agitates9310883agitates
airdates939723_airdates
ameerates1149063ameerates
amidases1136653amidases
animates101316423animates
aspirates1139613aspirates
aviates10313063avi_ates
bemires113212833bemir__es
berates94126873_berates
borates94823013_borates
carates95630613_carates
celibates1358633celibates
cerates95428253_cerates
citrates102315093citrates
climates12311973climates
crates85736063__crates
curates95323833_curates
deaerates10313643deaerates
deaminates1349383deaminates
decimates14410693decimates
decorates12314743decorates
dedicates13311693dedicates
delicates12314313delicates
demarcates1545973demarcates
denigrates1298113denigrates
denitrates1169513denitrates
depilates12310923depilates
depurates1239823depurates
derates84028893_derates
derivates13310093derivates
deviates12312733devi_ates
dilates83220663_dilates
disrates91118153disrates
dominates12311743dominates
ecartes94212563ecar_tes
educates1139623educates
elates65032363e__lates
elevates111110423elevates
eliminates1246973eliminates
elites66027123eli__tes
eluates72014683e_luates
emaciates1347883emaciates
emanate9312473emanate_
emanated1139163emanated
emblazes2135673emblazes
embrace1388893embrace_
embraced15106673embraced
embracer1496463embracer
embracers15105153embracers
embrocates1665013embrocates
embrues1136473embr_ues
embrute1145703embrute_
embruted1344353embruted
emeerate10410103emeerate_
emendates1246083emendates
emeralds1144593emeralds
emerges101310883emer_ges
emeries91620023emer_ies
emeritas1046433emeritas
emeritus1045173emeritus
emeutes938013em_eutes
emigrants1244733emigrants
emigres1037673emi_gres
emirs76116163emir___s
emits75421473emi__t_s
emitted103010853emi_tted
emitter93211083emi_tter
emitters10349643emi_tters
emotes84620283em__otes
empales112411433em_pales
emphases1568353emphases
empires1139853empir__es
emplaces1438413emplaces
emplanes1239503emplanes
emprises12311003emprises
emprizes2138133emprizes
emulate9314123emulate_
emulated11310793emulated
enates64026433e__nates
enervates1248723enervates
enframes1357453enframes
engraves1237233engraves
enrages83114853e_nrages
enumerates12126743enumerates
ephorates1459163ephorates
epidotes1147023epidotes
epilate9314283epilate_
epilated11310753epilated
epitases1038933epitases
equates162012323e_quates
erases64425403e__rases
ergates8314493e_rgates
erratas736863e_rratas
estates74520183e_states
estimates11911363estimates
estivates12109753estivates
etiolates949213etiolates
eucrites1049483eucrites
evites94916473evi__tes
excretes1787573excretes
execrates1839563execrates
expiates17810213expiates
extirpates1943683extirpates
exudates1636623exudates
federates13310153federates
ferrates113013423ferrates
fixates1737393_fixates
frigates12310933frigates
fumarates1445393fumarates
fumigates1545573fumigates
geminate11411813geminate_
geminated1338553geminated
gemmates13307673gem_mates
generates10312713generates
germinates1347763germinates
grates75429893__grates
gyrates113610263_gyrates
hesitates1269793hesitates
hydrates15229413hydrates
imamates1237663imamates
imbrutes1244203imbrutes
imitate9310873imitate_
imitated1138263imitated
immigrates1544023immigrates
ingrates9514173ingrates
irades74517393__irades
irate55627983__irate_
irater65218353__irater
iratest7312483__iratest
iterates81317823iterates
karates115617473_karates
laminates112712903laminates
levigates1346493levigates
levirate1147623levirate_
levitates1247863levitates
librates103412953librates
ligates82318383_ligates
malates93522613_malates
mates75251363_m__ates
mediates112814063mediates
medicates14312113medicates
meditates1239813meditates
meliorates1288903meliorates
membranes1545563membranes
metates92720013_metates
migrate101314173_migrate_
migrated121110513_migrated
milages103114403_milages
minutes93513443_minutes
miracles1238333_miracles
mirage92313653_mirage_
mires75640883_mir__es
mirexes1636993_mirexes
mirths114912993_mir_ths
misate81222693_misate_
misdates111113633_misdates
mismates121114563_mismates
misrate91319143_misrate_
misrated111315383_misrated
mites75141803_mi__tes
morales93619403_morales
muriates10312083_muriates
mutates92215793_mutates
narrates8312763narrates
nidates8311893_nidates
nitrates82516223nitrates
nominates11311053nominates
numerates11199573numerates
operates10515413operates
opiates9312143opi_ates
orates64328613__orates
outrates82421373outrates
oxidates1636333oxidates
perorates11417023perorates
phorates13413043phorates
picrates122013213picrates
pirate82322883_pirate_
pirated102515613_pirated
prates84633163__prates
primates121515933primates
priorates11410763priorates
privates131812373privates
prorates10418073prorates
rates55352013___rates
recrates102420373recrates
regrates92618403regrates
remates93827113rem__ates
remigrate1249223remigrate_
remigrated1447493remigrated
resinates9314763resinates
revibrates1546273revibrates
ruinates8311883ruinates
ruminates11410193ruminates
separates11310743separates
seriates82620673seri_ates
serrates82617023serrates
smilaxes1744653smilaxes
smirches1535993smirches
smites83921923smi__tes
striates83417083striates
templates1348273templates
terminates12410003terminates
tirades8311723_tirades
titrates82314663titrates
umbrages1336623umbrages
umpirages1443343umpirages
uncrates10314563uncrates
uprates93814863_uprates
urates65027763__urates
urinates8314133urinates
variates111214983variates
venerates12312263venerates
veritates12310973veritates
vesicates14119033vesicates
vibrates132210613vibrates
virgates1237923_virgates
vizirates2144663vizirates

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.403443402.0
2DLD Change Limit1461622406.51622431.2
3Display Results2402400.0932580.6
 (SQL Overall)1786912407.01225483.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.