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

96 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
mikados144468(None) 
mikado1344511mikado_
aikidos1253882aikidos
mikvos1554022mik_vos
miladis1049822miladis
mirador1046502mirador
miradors1146852miradors
misadds1136302misadds
ados57633513___ados
aikido1135473aikido_
camisados1472563camisados
cicadas1235993cicadas
dados75522433__dados
didos76820813di__dos
dildos8179303di_ldos
dorados938203dorados
eidos65817753ei__dos
fados95620733__fados
fidos95819053fi__dos
gitanos837173gitanos
ikats95311153_ika_ts
imagos9117553_imagos
irades74517393_irades
jihads1734483jihad_s
kadis105921063__kadis
kakapos1243673kakapos
kayos127714703__kayos
kiddos12416863ki_ddos
kudos105011253__kudos
libidos1044653libidos
lidos65219883li__dos
macacos1338083macacos
mads76845373m__ad_s
makars124612633maka_rs
makos116518363m__akos
manos74933623m__anos
matador1066253matador
matadors1156983matadors
mayos105521933m__ayos
meadow1237403m_eadow
meadows1337333m_eadows
meads85425323m_ead_s
megadose1244493megadose
menads95514383menad_s
menudos1034643menudos
miaou7513083mi_a_ou
miaous8511693mi_aous
miaow1058353mi_a_ow
miaows1145473mi_aows
miasms1097383mi_asms
miauls8178713mi_auls
micas96823053mica__s
micros104115363mi_cros
midairs1037203midairs
middays14335663middays
midis85923413mi__dis
mids76541783mi__d_s
miked125020453miked__
mikes115129893mik__es
mikron12318503mik_ron
mikrons13428413mikrons
mikvahs19162493mikvahs
mikvehs19111683mikvehs
mikvot1556763mik_vot
miladi938883milad_i
miladies1139923miladies
milady1236613milad_y
milages103114403milages
milds86422053mi_ld_s
milos75428013mi__los
mimeos104511543mi_meos
minas75434113mina__s
minds85427123mi_nd_s
mirages102213533mirages
misacts1139353misacts
misadd1037163misad_d
misaims11310113misaims
misdo85413183mi_sdo_
misdoes10312493mi_sdoes
miskals13369763miska_ls
misos76523293mi__sos
monades103713823monades
monads94515303monad_s
mondos95217333m_ondos
nicads938333nicad_s
parados103816053parados
pianos84315933pi_anos
picador1245923picador
picadors1345853picadors
picaros11310893picaros
pikakes1245823pikakes
pikas114218093pika__s
pintados11105993pintados
sikas94617023sika__s
tirades8311723tirades
viragos1146713viragos

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027966.92319359.7
3Display Results96960.0303200.0
 (SQL Overall)178691967.10925135.9
 
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.