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

269 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
amirates10111479(None) 
amirate91115951amirate_
emirates101214851emirates
acierates11310812acierates
aerates74627492a_erates
agitates9310882agitates
airdates939722a_irdates
ameerates1149062ameerates
amidases1136652amidases
animates101316422animates
aspirates1139612aspirates
aviates10313062avi_ates
emigrates1248582emigrates
emirate91015832emirate_
imitates10310502imitates
laminates112712902laminates
migrates111112852_migrates
mirages102213532_mirages
misrates101318242_misrates
pirates93020332_pirates
abates85825033a__bates
abdicates1448153abdicates
ablates92416903a_blates
abominates1446513abominates
abrades10312073a_brades
accretes1238113accretes
acerate92818913acerate_
acerated113113983acerated
acerbates1347263acerbates
acetates102013063acetates
acierate10311813acierate_
acierated1238283acierated
activates1449683activates
actuates10310313actuates
acuminates1446883acuminates
acylates1339743acylates
admirals1144353admira_ls
admiralties1452093admiralties
admires1038663admir__es
adulates9311913adulates
adumbrates1553133adumbrates
aerate64830553a_erate_
aerated85322373a_erated
agates76121343a__gates
agemates111110023agemates
aggrades1135863aggrades
agitate8312063agitate_
agitated1038413agitated
agminate1139243agminate_
agnates82813193a_gnates
agrafes1137523a_grafes
airdate8311323a_irdate_
airfares1146693a_irfares
airted74214503a_ir_ted
airths95414253a_ir_ths
airts55626343a_ir_t_s
airwaves1444723a_irwaves
alates64833973a__lates
alginates10310123alginates
aliases7914493ali_ases
alidades1037003alidades
alienates9310683alienates
aliterates101510763aliterates
aluminates1248363aluminates
amaranths1443553amaranths
amarones10311353amarones
amazes175613473am__azes
ambages1269623am_bages
ambaries123312383ambaries
ambries111614553ambr_ies
ambsaces1455213ambsaces
ambulates1348383ambulates
ameerate1039633ameerate_
ameliorates1354243ameliorates
amerces1149853amer_ces
amesaces1246693amesaces
amiantus1044383amiantus
amias75831473ami_a__s
amices105018013ami__ces
amidase1036733amidase_
amides95722663ami__des
amidines113010853amidines
amidones11348663amidones
amies76837693ami___es
amigas95912173amiga__s
amines84727983ami__nes
aminities11312913aminities
amirs75924923amir___s
amities9317383ami_ties
amitoses1039053amitoses
amitroles1144723amitroles
amniotes1036603amniotes
amosites10311233amosites
amperages1447683amperages
amputates1345263amputates
amritas939093am_ritas
amtracks1696633amtracks
amtracs1198883amtra_cs
amylases1346663amylases
animate91617213animate_
animated111612373animated
animater101512393animater
animaters11129973animaters
annates72415423a_nnates
apiaries10312733apiaries
apyrases1337243apyrases
arames84622573a__rames
arbitrates12117013arbitrates
aretes64425353a__retes
ariettes8411353ariettes
arrases71214543a_rrases
asperates11312553asperates
aspirate1039943aspirate_
aspirated1247703aspirated
attrites8311563attrites
aurate64426473a_urate_
aurated83817793a_urated
averages1249183averages
aviaries1139783aviaries
aviate9315203avi_ate_
aviated11310263avi_ated
axites134913833axi__tes
azurites1737283azurites
berates94126873_berates
borates94823013_borates
calibrates1446953calibrates
califates14310113califates
camisades1474963camisades
carates95630613_carates
castrates11312673castrates
cavitates14168963cavitates
cerates95428253_cerates
citrates102315093citrates
climates12311973climates
crates85736063__crates
curates95323833_curates
deaminates1349383deaminates
derates84028893_derates
dilates83220663_dilates
disrates91118153disrates
dominates12311743dominates
emanates10311333emanates
embraces14128873embraces
embrutes1245193embrutes
emeerates1149373emeerates
emigrate1149603emigrate_
emigrated1347073emigrated
emulates10312573emulates
epilates10313503epilates
ferrates113013423ferrates
fixates1737393_fixates
frigates12310933frigates
fumarates1445393fumarates
fumigates1545573fumigates
geminates12310043geminates
grates75429893__grates
gyrates113610263_gyrates
hamates122917683ham__ates
hydrates15229413hydrates
imamates1237663imamates
imbrutes1244203imbrutes
imitate9310873imitate_
imitated1138263imitated
immigrates1544023immigrates
ingrates9514173ingrates
irades74517393__irades
irate55627983__irate_
irater65218353__irater
iratest7312483__iratest
iterates81317823iterates
kalifates1646133kalifates
kamikazes2341173kamikazes
karates115617473_karates
labiates101011513labi_ates
lacerates112413783lacerates
laminate103014633laminate_
laminated122610283laminated
lapidates1247143lapidates
levirates1247493levirates
librates103412953librates
ligates82318383_ligates
macerates132113573macerates
macrames1438953macrames
madrases112610003madrases
magnates11511613magnates
malates93522613_malates
maleates103316343maleates
mandates11314093mandates
marinates112516383marinates
mates75251363_m__ates
maturates11311763maturates
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
navigates1345873navigates
nidates8311893_nidates
nitrates82516223nitrates
nominates11311053nominates
numerates11199573numerates
operates10515413operates
opiates9312143opi_ates
orates64328613__orates
outrates82421373outrates
oxidates1636333oxidates
paginates123111363paginates
palmitates1445453palmitates
patinates113814693patinates
patriates11311363patriates
phorates13413043phorates
picrates122013213picrates
pirate82322883_pirate_
pirated102515613_pirated
prates84633163__prates
primates121515933primates
priorates11410763priorates
privates131812373privates
prorates10418073prorates
radiates92415293radi_ates
radicates12412073radicates
rates55352013___rates
recrates102420373recrates
regrates92618403regrates
remigrates1348583remigrates
ruinates8311883ruinates
ruminates11410193ruminates
salivates1239293salivates
samites93118713sami__tes
sanitates9611733sanitates
satiates8314633sati_ates
saturates9811603saturates
seriates82620673seriates
serrates82617023serrates
smilaxes1744653smilaxes
smirches1535993smirches
smites83921923smi__tes
striates83417083striates
tartrates979563tartrates
tirades8311723_tirades
titrates82314663titrates
umbrages1336623umbrages
umpirages1443343umpirages
uncrates10314563uncrates
uprates93814863_uprates
urates65027763__urates
urinates8314133urinates
valerates12310543valerates
validates1338243validates
vambraces1843773vambraces
variates111214983vari_ates
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.423422437.4
2DLD Change Limit1461622696.48322545.4
3Display Results2692690.1102445.5
 (SQL Overall)1786912697.01625469.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.