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

146 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
dinkums143367(None) 
dinkum1335891dinkum_
bunkums1544052bunkums
dictums1235552dictums
dingus83611842dingu_s
dinkeys15507262dinkeys
dinkies123716032dinkies
dinks105927952dink__s
dirdums1134382dirdums
linkups1333632linkups
linums838282lin_ums
miniums113910222miniums
trinkums1443412trinkums
ankus91410683_anku_s
bunkum1435983bunkum_
centums11398783centums
cinques1837333cinques
coniums11311863coniums
crinums1135863crin_ums
cundums1235183cundums
datums936353d_atums
degums10438623d_egums
dengues938183dengues
denims95214323den_ims
diadems1135393diadems
diatoms1039073diatoms
dibbuks1643163dibbuks
dickens144410133dickens
dickers144117663dickers
dickeys17479303dickeys
dickies143416343dickies
dicks125824693dick__s
dictum1136863dictum_
dikers114418793di_kers
dikes105831333di_k_es
dimouts1037893dimouts
dims75435023di___ms
dinars75417563din_ars
dindles93817243dindles
dineros83812333dineros
diners75525953din_ers
dines66449153din__es
dingers94321383dingers
dinges83825423din_ges
dingeys12458403dingeys
dingies93618243dingies
dingles93818323dingles
dingoes94114833dingoes
dings76331403din__gs
dinguses1037643dinguses
dink97137803dink___
dinked124818353dink_ed
dinkey144812763dink_ey
dinkier123411503dinkier
dinkiest133812873dinkiest
dinking133618283dinking
dinkly144311083dink_ly
dinky135819373dink__y
dinners83915443dinners
dinos65428063din__os
dins56652043din___s
dints67431313din__ts
dirams94413703di_rams
dirdum1036033dirdum_
dirhams13376313dirhams
dirks105619523dirk__s
disarms1039043disarms
disbuds11125243disbuds
discus94512113discu_s
discuss10357953discuss
diseurs839403diseurs
disks105417473disk__s
dominiums1444983dominiums
donkeys15426663donkeys
donuts7410583don_uts
doums85417643d__oums
drinkers13277823drinkers
drinks116810713drink__s
drums85415873d__rums
dubniums1343153dubniums
dumdums1343043dumdums
dunams937833dun_ams
dunkers123512193dunkers
dunks105621193dunk__s
durums948153d_urums
fanums1137263fan_ums
finks125424223fink__s
ginkgos13314183ginkgos
ginks104319563gink__s
hokums1533923_hokums
imaums10106303_imaums
inarms8410093_inarms
incurs83012283_incurs
incus73315053_incu_s
indiums1037143_indiums
indues73515263_indues
inhume1196583_inhume
inhumes1296883_inhumes
inkers104018833_inkers
inkles103515653_inkles
inks86926503_ink__s
inputs837703_inputs
inruns6359513_inruns
ioniums938313ioniums
jinkers183511813jinkers
jinks165019333jink__s
kickups1443503kickups
kinks84926083kink__s
lineups934913lineups
lingams104510193lingams
linkers114317713linkers
links96430193link__s
linkup1245123linku_p
linum7313823lin_um_
minims104514813min_ims
minimums11404603minimums
minium106014423minium_
minkes124618783mink_es
minks115829273mink__s
minus75223933min_u_s
neums75414253__neums
oakums1264153_oakums
odiums9337943odi__ums
oinks94819913oink__s
pickups1754253pickups
pinkens13419643pinkens
pinkers134118603pinkers
pinkeys16378213pinkeys
pinkies133818263pinkies
pinkoes135512313pinkoes
pinkos125313873pink_os
pinks115729383pink__s
pinups1037413pin_ups
rinks94827103rink__s
sinkers113618543sinkers
sinks95529183sink__s
sinus55523853sin_u_s
stickums1643943stickums
tinfuls1036593tinfuls
tinkers113517143tinkers
tinkles113713923tinkles
vinous93914173vinou_s
windups1334783windups
winkers143517113winkers
winkles143412773winkles
winks125325433wink__s

Search took 7 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.403443402.0
2DLD Change Limit1340271466.00022337.8
3Display Results1461460.0463173.9
 (SQL Overall)1786911466.44927708.3
 
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.