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

127 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
minikins1420832(None) 
manikins14189721manikins
minikin13258981minikin_
canikins14219162canikins
finikin14266862finikin_
finiking16277072finiking
manakins14209762manakins
manikin132110242manikin_
mannikins15215092mannikins
minifies13312902minifies
minions93314622mini_ons
miniskis1444452miniski_s
minivans1345412minivans
amanitins1147133amanitins
aminities11312913aminities
anilins7416793_anilins
canakins142010463canakins
canikin13189753canikin_
cannikins15225683cannikins
cinerins10414103cinerins
dinkies123716033din_kies
dinking133618283din_king
finickin1773633finickin_
finicking1954463finicking
finking154016603fin_king
firkins1437663fi_rkins
inhibins1344893_inhibins
inions64417003_ini_ons
inking115119053_in_king
inulins7311493_inulins
jinking193613543jin_king
kidskins1243453kidskins
kinetins12228153kinetins
kingpins1544903kingpins
kinins104014583kin__ins
kinking113615153kin_king
kipskins1343263kipskins
limpkins1644233limpkins
linins65922143lin__ins
linking123818253lin_king
maintains1167103maintains
malkins133311803m_alkins
manakin131810643manakin_
mankind1437773man_kind
mannikin14215503mannikin_
maximins1944533maximins
midirons1145883midirons
miking134218463m__iking
militias1048633militias
milking143712763mi_lking
mimicking2043873mimicking
mincing123314333min_cing
minding113317893min_ding
mingling122010933mingling
minibars1296553minibars
minibike1653793minibike
minibikes1743693minibikes
minibus1136343mini_bus
minicabs14135073minicabs
minicams14126873minicams
minicars12118523minicars
minidisc1344143minidisc
minidiscs1442873minidiscs
minified1439653minified
minifying1845823minifying
minilabs12124573minilabs
minimals12327433minimals
minimill1244483minimill
minimills1343843minimills
minimise1246863minimise
minimises1347163minimises
minimize2146063minimize
minimizes2246123minimizes
minims104514813min__ims
minimums11404603minimums
mining94225453min__ing
minings103912073mini_ngs
minion83416243mini_on_
minipill1244353minipill
minipills1343523minipills
minis75432993min__i_s
minishes13310583minishes
minishing1547073minishing
miniski1344483miniski__
miniskirt1553523miniskirt
miniskirts1651733miniskirts
miniums113910223mini_ums
minivan1245713minivan_
minivers1337483minivers
minkes124618783min_k_es
minks115829273min_k__s
minnies93617363min_nies
minoring11311473minoring
minting103020813min_ting
minuting1139723minuting
minyans1237263min_yans
mirins83918903m__irins
miscoins12311083miscoins
misjoins1736913misjoins
misliking1637113misliking
monikers1437413monikers
monitions11310883monitions
monokine1448483monokine
monokines1547903monokines
munchkins2042913munchkins
munitions1138173munitions
muntins92715133mun_tins
nankins1159053nan_kins
ninepins1045873ninepins
oilskins1243873oilskins
oinking123714713oin_king
pannikins15204843pannikins
pigskins1544253pigskins
pinions93413603pini_ons
pinkens13419643pin_kens
pinkies133818263pin_kies
pinking143918943pin_king
pinkings15338143pin_kings
pipkins15328183pi_pkins
punkins133111113pun_kins
sinking123320543sin_king
siskins1159583si_skins
spilikins1543543spilikins
vinifies1439873vinifies
wineskins1644213wineskins
winking153317963win_king
zincking2435463zincking

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.436409841.7
2DLD Change Limit1461621277.04620744.0
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.54523683.4
 
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.