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

314 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
dike9593577(None) 
bike106532611bike
deke95228761deke
dice75841901dice
die46759661di_e
diked115024681diked
diker105524551diker
dikes105831331dikes
dikey135116421dikey
dime76237651dime
dine55555341dine
dire56644151dire
dite55547561dite
dive85634781dive
duke95628101duke
dyke126418181dyke
hike116830401hike
kike76524801kike
like86040851like
mike105535301mike
pike106335221pike
sike87138791sike
tike85534491tike
aide56045012aide
alike95523962alike
bake105637512bake
bice86235572bice
bide76041512bide
biked125320032biked
biker116022562biker
bikes117529472bikes
bikie113915882bikie
bile66147192bile
bine66650872bine
bise66437112bise
bite66547012bite
bize155926302bize
cake105439962cake
cine66242952cine
cire65836382cire
cite65640352cite
coke107038382coke
cuke105824982cuke
dace76934922dace
daiker115113032daiker
dak86340692dak_
daks97130602daks
dale55643982dale
dame77140312dame
dare55848862dare
date56443322date
daze147327232daze
de37049552d__e
dee47665822d_ee
deice84320032deice
deked115718532deked
dekes105224452dekes
dele56843082dele
deme76536282deme
dene56643412dene
dere56845902dere
dial55935072dial
dib65746952di_b
dibs76233692dibs
diced95824682diced
dicer85426422dicer
dices86434242dices
dicey114819332dicey
dick116432392dick
dicked144920862dicked
dicker134521402dicker
dickey165913522dickey
dickie133913112dickie
dicks125824692dicks
dicky154816242dicky
did56850532di_d
didie74120572didie
dido66528212dido
didy99121522didy
died66137862died
diel59034612diel
diene65720132diene
dies55653532dies
diet57357542diet
dif76846912di_f
diff116228852diff
difs86027332difs
dig57544482di_g
digs66036062digs
dikers114418792dikers
dill55239982dill
dim68146502di_m
dimer85625602dimer
dimes85833042dimes
dims75435032dims
din46459472di_n
dined76431992dined
diner65632902diner
dines66449152dines
ding66940962ding
dinge75627302dinge
dink97137812dink
dinked124818352dinked
dinkey144812762dinkey
dinks105927952dinks
dinky135819372dinky
dino56036762dino
dins56652052dins
dint56759062dint
diode74716122diode
diol57329142diol
dip67848992di_p
dips75536922dips
dipt77339332dipt
direr64927072direr
dirge75117072dirge
dirk96326842dirk
dirked124912272dirked
dirks105619522dirks
dirl57430032dirl
dirt55550392dirt
dis46459902di_s
disc76123242disc
dish86328342dish
disk96625842disk
disked125015762disked
disks105417472disks
disme85716242disme
diss56434492diss
dit47071342di_t
dita56032532dita
dites66339152dites
dits56450532dits
ditz146929522ditz
diva85920892diva
dived106321372dived
diver94827802diver
dives95832402dives
dizen155214932dizen
doe47361952d_oe
doge66233802doge
dole56550002dole
dome77240732dome
done55747912done
dope76038892dope
dore56353302dore
dose56442432dose
dote55442882dote
dove85131562dove
doze145829082doze
drake104918302drake
dree56638322dree
drek96321092drek
drive95318002drive
duce76933502duce
dude65629672dude
due45249862d_ue
duiker114110592duiker
duked115218462duked
dukes105023472dukes
dune56137582dune
dupe76630602dupe
dure56341812dure
dwine95616142dwine
dye75334842d_ye
dyked145310952dyked
dykes135215572dykes
dykey16608672dykey
dyne85320932dyne
edile64819492edile
eide55832252eide
eke75630092_eke
fake115534942fake
fice95737122fice
fie67152452fi_e
fife106027712fife
file75446652file
fine75147962fine
fire76245602fire
five107629752five
fyke145915292fyke
gibe75927792gibe
gie47149552gi_e
gite55438622gite
give85829362give
hake115637842hake
hide85134652hide
hie67652712hi_e
hiked135919202hiked
hiker125119392hiker
hikes125426982hikes
hire75538972hire
hive106029682hive
hoke115935932hoke
ice56737252_ice
idle55423772idle
ire36943182_ire
jake155925772jake
jibe136323402jibe
jive146123602jive
joke155926162joke
juke154721662juke
kibe106523462kibe
kikes85122562kikes
kine85643442kine
kite85338252kite
lake85741602lake
leke85527402leke
lice66045072lice
lie38264532li_e
life75433742life
liked104523812liked
liken911818842liken
liker95627062liker
likes96231902likes
lime66244942lime
line46965582line
lipe66839742lipe
lire47845302lire
lite47054552lite
live76541002live
make105537892make
mice87442242mice
miked125020452miked
mikes115129892mikes
mile66352582mile
mime85736412mime
mine67256182mine
minke115421762minke
mire66748242mire
mise66043592mise
mite66249422mite
moke106234222moke
nice65534722nice
nide55535802nide
nine45842182nine
nite45943592nite
nixe115722032nixe
nuke85920752nuke
oke75839482_oke
peke105926202peke
pice84641102pice
pie55457412pi_e
pika106322962pika
piked125623312piked
piker115622842piker
pikes115031032pikes
piki106520572piki
pile65649702pile
pine67755722pine
pipe86434442pipe
poke105335362poke
puke105025462puke
rake84841572rake
rice64942922rice
ride55945142ride
rife74632332rife
rile45650542rile
rime65138892rime
ripe66038932ripe
rise45945242rise
rite45849462rite
rive75537732rive
ryke115616402ryke
sake85244962sake
sice65545602sice
side55444502side
sika86021332sika
siker95326032siker
sikes96236082sikes
sine46560632sine
sipe67341052sipe
sire46150422sire
site47052422site
size135630972size
soke85436262soke
spike114922842spike
syke115420562syke
take84739262take
tide55237392tide
tie36557542ti_e
tikes95628902tikes
tiki87620852tiki
tile45451452tile
time66235022time
tine45855142tine
tire46143362tire
toke86738492toke
trike95320162trike
tyke115720502tyke
uke75727292_uke
vibe95124512vibe
vice95732862vice
vide85432772vide
vie65447642vi_e
vile76139812vile
vine75643692vine
vise75632682vise
vive105426632vive
wake114935702wake
wide85235422wide
wife105228032wife
wile75944382wile
wine74953432wine
wipe94830292wipe
wire75839822wire
wise75737352wise
wite75443282wite
wive105931762wive
woke115527962woke
yikes125117752yikes
yipe96722192yipe
yoke115626392yoke
zine137036162zine

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.283631417.0
2DLD Change Limit298723140.89033564.0
3Display Results3143140.0764131.6
 (SQL Overall)1786913141.249143067.3
 
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.