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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

152 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
dinky13581937(None) 
dicky154816241dicky
dingy105721261dingy
dink97137801dink_
dinkey144812761dinkey
dinkly144311081dinkly
dinks105927951dinks
hinky155618751hinky
inky115321581_inky
kinky115816381kinky
linky127622381linky
pinky145823401pinky
zinky215314811zinky
chinky185610542chinky
conky145818742conky
dainty105311472dainty
dandy104416702dandy
dank95828242dank_
dankly14419462dankly
darky136018832darky
deny86027122den_y
diary95016972diary
dicey114819332dicey
dick116432382dick_
dickey165913522dickey
dicks125824692dicks
dicty115116292dicty
didy99121512di_dy
dike95935762di_ke
dikey135116422dikey
dilly94923782dilly
dimly114913482dimly
din46459462din__
dinar66319892dinar
dine55555332din_e
dined76431992dined
diner65632902diner
dines66449152dines
ding66940952din_g
dinge75627302dinge
dingey114914052dingey
dinghy14476962dinghy
dingo74720792dingo
dings76331402dings
dinked124818352dinked
dinkeys15507262dinkeys
dinkum1335892dinkum
dino56036752din_o
dinos65428062dinos
dins56652042din_s
dint56759052din_t
dints67431312dints
dippy135111542dippy
dirk96326832dirk_
dirks105619522dirks
dirty95617802dirty
dishy125712352dishy
disk96625832disk_
disks105417472disks
ditsy95612562ditsy
ditty95019292ditty
ditzy186513282ditzy
divvy15356482divvy
dizzy177410852dizzy
djinny1732872djinny
donkey14449732donkey
donsy96414682donsy
dorky135518742dorky
drink106816382drink_
drinks116810712drinks
ducky154216112ducky
dumky154511342dumky
dungy104713642dungy
dunk96228572dunk_
dunks105621192dunks
dusky135213042dusky
fink117532122fink_
finks125424222finks
finny114716752finny
funky154315132funky
gink97129522gink_
ginks104319562ginks
ginny95314572ginny
gunky135514112gunky
hanky155418292hanky
hinny115616672hinny
honky156218522honky
hunky155417732hunky
icky136315752_icky
inby95315662_inby
ink76433632_ink_
inks86926502_inks
inly75622212_inly
jink156227202jink_
jinks165019332jinks
junky194513232junky
kicky135012332kicky
kink76034402kink_
kinks84926082kinks
lanky125517482lanky
lindy96918312lindy
liney87029632liney
lingy96925142lingy
link86943442link_
links96430192links
linty87126562linty
liny78141322lin_y
milky144014442milky
mincy125817412mincy
mingy115520182mingy
mink106636532mink_
minke115421762minke
minks115829272minks
minny104518662minny
minty106323902minty
mirky146315522mirky
ninny84514932ninny
oink85429342oink_
oinks94819912oinks
picky165416942picky
piney105727502piney
pink107039382pink_
pinkey154314672pinkey
pinkly155012242pinkly
pinko115618252pinko
pinks115729382pinks
pinny105222062pinny
piny911838352pin_y
punky144419392punky
rindy95717392rindy
rink87736992rink_
rinks94827102rinks
risky126311522risky
silky125315822silky
sink86640142sink_
sinks95529182sinks
slinky13399102slinky
stinky134611072stinky
tinkly134811152tinkly
tinny85317652tinny
tiny76134632tin_y
viny106025952vin_y
windy126118102windy
winey115325432winey
wingy126521032wingy
wink116435022wink_
winks125325432winks
winy107034322win_y
wonky154011772wonky
zincky24404962zincky
zincy195413512zincy
zingy186516132zingy

Search took 3 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 Filter178691538000.343520965.0
2DLD Change Limit538001521.73630990.8
3Display Results1521520.0463304.3
 (SQL Overall)1786911522.12584089.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.