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 “minikin” 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
minikin1325898(None) 
finikin14266861finikin
manikin132110241manikin
minikins14208321minikins
canikin13189752canikin
finickin1773632finickin
finiking16277072finiking
manakin131810642manakin
manikins14189722manikins
mannikin14215502mannikin
minion83416242mini_on
miniski1344482miniski_
miniskis1444452miniskis
minivan1245712minivan
amanitin1048463amanitin
anilin6417793_anilin
canakin131810833canakin
canikins14219163canikins
cannikin14196073cannikin
cinerin9313823cinerin
dinking133618283din_king
finicking1954463finicking
finking154016603fin_king
firkin1337823fi_rkin
inhibin1244853_inhibin
inion54620183_ini_on
inking115119053_in_king
inulin6311733_inulin
jinking193613543jin_king
kidskin1143833kidskin
kinetin11248263kinetin
kingpin1445003kingpin
kinin94917333kin__in
kinking113615153kin_king
kipskin1243473kipskin
limpkin1534223limpkin
linin58025523lin__in
linking123818253lin_king
maintain1077723maintain
malkin122913153m_alkin
manakins14209763manakins
mankind1437773man_kind
mannikins15215093mannikins
maximin1835263maximin
midiron1046003midiron
miking134218463m__iking
militia949733militia
milking143712763mi_lking
mimicking2043873mimicking
mincing123314333min_cing
minding113317893min_ding
mingling122010933mingling
mini65634573min__i_
minibar11106133minibar
minibike1653793minibike
minibus1136343minibus
minicab13177173minicab
minicam131110063minicam
minicar11109323minicar
minidisc1344143minidisc
minified1439653minified
minifies13312903minifies
minify1439253mini_fy
minifying1845823minifying
minilab11126003minilab
minim97321603min__im
minima105512653mini_ma
minimal114010603minimal
minimax18376013minimax
minimill1244483minimill
minimise1246863minimise
minimize2146063minimize
minims104514813mini_ms
minimum10456143minimum
mining94225453mini_ng
minings103912073minings
minions93314623minions
minipill1244353minipill
minis75432993min__is
minish115216313mini_sh
minishing1547073minishing
miniskirt1553523miniskirt
minium106014423mini_um
miniums113910223miniums
minivans1345413minivans
miniver1238393miniver
mink106636543min_k__
minke115421763min_k_e
minkes124618783min_kes
minks115829273min_k_s
minoring11311473minoring
minting103020813min_ting
minutia946423minutia
minuting1139723minuting
minyan1138173min_yan
mirin75023153m__irin
miscoin11311433miscoin
misjoin1637693misjoin
mislain9311243mislain
misliking1637113misliking
moniker1338673moniker
monition10311723monition
monokine1448483monokine
munchkin1943233munchkin
munition1038763munition
muntin82915183mun_tin
nankin1039673nan_kin
ninepin945573ninepin
oilskin1144473oilskin
oinking123714713oin_king
pannikin14194923pannikin
pigskin1444353pigskin
pinion83815893pini_on
pinken124513283pin_ken
pinkie124414273pin_kie
pinking143918943pin_king
pinyin112710613pin_yin
pipkin14248603pi_pkin
punkin123611523pun_kin
sinking123320543sin_king
siskin1079783si_skin
spilikin1443763spilikin
unakin10310963_unakin
wineskin1544243wineskin
winking153317963win_king
zincking2435463zincking

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271267.69017428.7
3Display Results1261260.0462739.1
 (SQL Overall)1786911268.14221946.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.