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

195 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
disk9662584(None) 
bisk106523361bisk
desk95618901desk
dick116432391dick
dink97137811dink
dirk96326841dirk
dis46459901dis_
disc76123241disc
dish86328341dish
disks105417471disks
diss56434491diss
dusk95724151dusk
risk85724111risk
ais39083582ais_
ask77130702_ask
bask105131422bask
bilk105824432bilk
birk106326872birk
bis56860672bis_
bise66437112bise
bisks115416802bisks
bosk105825732bosk
brisk115615982brisk
busk105429222busk
cask105626432cask
cis57748042cis_
cist67244972cist
cusk105521632cusk
dais57040702dais_
daisy95915312daisy
dak86340692d_ak
daks97130602daks
dank95828242dank
dark95133212dark
dash87031632dash
dawk126117282dawk
deck115827752deck
deism84116032deism
deist64633592deist
desks105913072desks
dhak125512032dhak
dial55935072dial
dib65746952di_b
dibs76233692dibs
dice75841902dice
dicks125824692dicks
dicky154816242dicky
did56850532di_d
dido66528212dido
didst74619622didst
didy99121522didy
die46759662di_e
died66137862died
diel59034612diel
dies55653532dies
diet57357542diet
dif76846912di_f
diff116228852diff
difs86027332difs
dig57544482di_g
digs66036062digs
dike95935772dike
dill55239982dill
dim68146502di_m
dime76237652dime
dims75435032dims
din46459472di_n
dine55555342dine
ding66940962ding
dinks105927952dinks
dinky135819372dinky
dino56036762dino
dins56652052dins
dint56759062dint
diol57329142diol
dip67848992di_p
dips75536922dips
dipso85111552dipso
dipt77339332dipt
dire56644152dire
dirks105619522dirks
dirl57430032dirl
dirt55550392dirt
disci85815022disci
disco85616072disco
discs85316262discs
dishy125712352dishy
disked125015762disked
disme85716242disme
dit47071342di_t
dita56032532dita
dite55547562dite
dits56450532dits
ditsy95612562ditsy
ditz146929522ditz
diva85920892diva
dive85634782dive
dock116228742dock
dork96531462dork
dos48062312dos_
dose56442432dose
doss56235042doss
dost57248352dost
drek96321092drek
drink106816382drink
duck115929172duck
dunk96228572dunk
dusks105317252dusks
dusky135213042dusky
dust57142532dust
fink117532132fink
fisc96819762fisc
fish106926282fish
fist76248432fist
frisk125312372frisk
gink97129532gink
gist56046772gist
hick135530312hick
his66359512his_
hisn79620942hisn
hiss75629222hiss
hist76551552hist
husk116021952husk
ick97329332_ick
ids47535482ids_
ilk78325312_ilk
ink76433642_ink
irk76426372_irk
is27048222_is_
ism56322392_ism
jink156227212jink
jism135514782jism
kick96026082kick
kink76034412kink
kiosk836242kiosk
kirk76221582kirk
kis78051492kis_
kiss85227412kiss
kist86540812kist
lick106935082lick
link86943452link
lis37162282lis_
lisp68926892lisp
list47055352list
mask105227362mask
mick126333442mick
milk105028482milk
mink106636542mink
mirk106729512mirk
mis58162632mis_
mise66043592mise
miso67229912miso
miss65339432miss
mist66154542mist
mosk105622442mosk
musk104526192musk
nick106627612nick
nisi45823252nisi
odist6421912odist
oink85429352oink
pick125933822pick
pink107039392pink
pis56362042pis_
pish96127922pish
piso66727572piso
piss65033342piss
qis126934392qis_
rick107334662rick
rink87737002rink
rise45945242rise
risks94917062risks
risky126311522risky
rusk85823312rusk
sick106435582sick
silk85529332silk
sink86640152sink
sis37360552sis_
task85326652task
tick106231232tick
tis37056652tis_
tsk75814732_tsk
tusk85621632tusk
vis66747622vis_
visa76323882visa
vise75632682vise
whisk154510142whisk
wick135726312wick
wink116435032wink
wis66552342wis_
wise75737352wise
wish107228742wish
wisp97124082wisp
wiss75630552wiss
wist78049302wist
xis106935342xis_

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298721950.78038297.4
3Display Results1951950.0335909.1
 (SQL Overall)1786911951.079165608.0
 
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.