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 “miradors” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
miradors114685(None) 
mirador1046501mirador_
matadors1156982matadors
migrators1247542migrators
mikados1444682mikado_s
mirrors938622mir_rors
paradors113411902paradors
picadors1345852picadors
abraders1137343abraders
aerators8315613aerators
ardors74416873_ar_dors
biramous1266073biramous
birddogs1382433birddogs
birders103913263bir_ders
chadors1338753_chadors
citators10310253citators
compradors1743783compradors
curators10311723curators
dilators93213203dilators
dorados938203dorado_s
firedogs1344793firedogs
girasols984273girasols
girders9379943gir_ders
graders94716013_graders
gyrators1246003gyrators
imitators1147013imitators
irades74517393_irad_es
labradors1243793labradors
majors154511093m__ajors
malodors1144973malodors
manors84420883m__anors
marabous1249063marabous
marauders1244263marauders
markhors1745393markhors
matador1066253matador_
mayors115714193m__ayors
meadows1337333m_eadows
miaous8511693mi_a_ous
miaows1145473mi_a_ows
microdots1446883microdots
midairs1037203mida_irs
migrator1147873migrator_
migratory1545343migratory
mikado1344513mikado__
miladies1139923miladies
miladis1049823milad_is
minatory1338553minatory
minders103720123mi_nders
minors85117103mi__nors
miracles1238333miracles
mirages102213533mira_ges
mirror848003mir_ror_
misadds1136303misad_ds
misavers1348063misavers
misdoers1137103mi_sdoers
misdoes10312493mi_sdoes
mislabors1344513mislabors
moratory1347823moratory
murders103311363mur_ders
nitrators949213nitrators
orators7313823_orators
paraders113113113paraders
parador103311413parador_
paradores12259663paradores
parados103816053parado_s
picador1245923picador_
picadores1444363picadores
radars71314673__radars
radons74118533__radons
razors154711663__razors
sirdars8228213sir_dars
sordors8310013sor_dors
stridors9367323stridors
tirades8311723tirad_es
titrators948383titrators
toreadors1045153toreadors
traders84316953_traders
viators102712023vi_ators
vibrators14237253vibrators
viragoes1245233viragoes
viragos1146713virago_s

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 Filter1786911461620.453394461.4
2DLD Change Limit146162817.69019006.8
3Display Results81810.0302700.0
 (SQL Overall)178691818.17321863.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.