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

126 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
mikado134451(None) 
mikados1444681mikados
aikido1135472aikido
miked125020452miked_
miladi938882miladi
milady1236612milady
mirador1046502mirador
misadd1037162misadd
misdo85413182mi_sdo
ado49146873___ado
aikidos1253883aikidos
amido85720983ami__do
biked125320033biked_
camisado1372943camisado
ciao64924183ci_a_o
cicada1136413cicada
dado67126333__dado
diazo15310033di_azo
dido66528193di__do
diked115024683diked_
dildo71911773di_ldo
dorado838813dorado
fado87226463__fado
fido87726393fi__do
gitano738043gitano
hiked135919203hiked_
ikat87626643_ika_t
ikats95311153_ikats
imago8118693_imago
imido85812243_imido
irade65618153_irade
jiao115017843ji_a_o
jihad1635913jihad_
jihads1734483jihads
kadi96224823__kadi
kakapo1143853kakapo
kayo116417553__kayo
kiddo11398943ki_ddo
kudo96115103__kudo
libido935753libido
lido56028153li__do
liked104523813liked_
macaco1247853macaco
mad68958703m__ad_
made75440233m__ade
mads76845363m__ads
makar115614973maka_r
makars124612633makars
mako105622353m__ako
malady1237863malady
mano66536793m__ano
matador1066253matador
mayo96524293m__ayo
mead75531603m_ead_
meadow1237403m_eadow
meads85425323m_eads
menad85918983menad_
menads95514383menads
menudo945793menudo
miaou7513083mi_aou
miaow1058353mi_aow
miasm91211093mi_asm
miaul71612123mi_aul
mica86428253mica__
micas96823053mica_s
micro94715993mi_cro
mid67354463mi__d_
midair937993midair
midday13327503midday
middy124812593mi_ddy
midi75628473mi__di
mids76541783mi__ds
mike105535293mik__e
mikes115129893mik_es
miking134218463miking
mikra114610313mik_ra
mikron12318503mikron
mikvah18143473mikvah
mikvahs19162493mikvahs
mikveh18132543mikveh
mikvos1554023mikvos
mikvot1556763mikvot
miladis1049823miladis
milage93414123milage
mild75330853mi_ld_
milds86422053mi_lds
milked134612573milked_
milo65536103mi__lo
mimed105622733mimed_
mimeo96018683mi_meo
mina65136913mina__
minae75627723mina_e
minas75434113mina_s
mind75434373mi_nd_
minds85427123mi_nds
mined85333353mined_
miradors1146853miradors
mirage92313653mirage
mired85729223mired_
misact10316683misact
misadds1136303misadds
misaim10311853misaim
misate81222693misate
miskal123710263miska_l
miskals13369763miskals
mismade12129353mismade
miso67229903mi__so
mixed155717253mixed_
monad85519473monad_
monads94515303monads
mondo85721233m_ondo
nicad8312613nicad_
nicads938333nicads
piano76118713pi_ano
picador1245923picador
picaro10311323picaro
pika106322953pika__
pikake11115803pikake
pikas114218093pika_s
piked125623313piked_
pintado1096573pintado
sika86021323sika__
sikas94617023sika_s
spado83713703_spado
tirade7311693tirade
virago1046643virago

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161265.65619928.6
3Display Results1261260.0333818.2
 (SQL Overall)1786911265.82930655.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.