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

165 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
dicker13452140(None) 
bicker144819171bicker
dacker134920751dacker
decker135215991decker
dicer85426421dic_er
dicier94416231dicier
dicked144920861dicked
dickers144117661dickers
dickey165913521dickey
dickier143512451dickier
diker105524551di_ker
docker134417651docker
ducker134317991ducker
icker114018441_icker
kicker114116181kicker
licker125222041licker
nicker123818701nicker
picker144422171picker
sicker124023901sicker
ticker124321501ticker
wicker154518671wicker
backer144525522backer
bickers154316552bickers
biker116022562bi_ker
bilker124913442bilker
bucker145420462bucker
clicker154111882clicker
cocker144320392cocker
dackers143417042dackers
daiker115113032daiker
danker114319662danker
darker114718692darker
decked145217622decked
deckel134911042deckel
deckers144413832deckers
deicer94114412deic_er
deticker1545282deticker
dialer74315432dialer
diaper94513112diaper
dibber114614712dibber
dice75841892dic_e_
diced95824682dic_ed
dicers94720742dic_ers
dices86434242dic_es
dicey114819332dic_ey
dick116432382dick__
dickens144410132dickens
dickered16117532dickered
dickeys17479302dickeys
dickie133913112dickie
dickies143416342dickies
dicks125824692dick_s
dicky154816242dick_y
dictier103411862dictier
dieter73516772dieter
differ133910842differ
digger94616082digger
dike95935762di_ke_
diked115024682di_ked
dikers114418792di_kers
dikes105831332di_kes
dikey135116422di_key
dimer85625602di_mer
dimmer114112612dimmer
diner65632902di_ner
dinger85323672dinger
dinked124818352dinked
dinkey144812762dinkey
dinkier123411502dinkier
dinner74217162dinner
dipper114017792dipper
direr64927072di_rer
dirked124912272dirked
disked125015762disked
ditcher134012002ditcher
dither104417682dither
diver94827802di_ver
docked145018332docked
dockers143715002dockers
docket134721172docket
drinker12349482drinker
ducked144718012ducked
duckers143214712duckers
duckier143911792duckier
duiker114110592duiker
dunker113616462dunker
fickler16348422fickler
flicker163610622flicker
fucker153414422fucker
hacker154822692hacker
hickey185011992hickey
hiker125119392hi_ker
hocker155118562hocker
icier74313752_icier
ickers123914182_ickers
ickier12439922_ickier
inker94421092_inker
jacker194417582jacker
jinker174013542jinker
kicked124415942kicked
kickers124013292kickers
kickier12349052kickier
lacker125325622lacker
licked134621562licked
lickers134118252lickers
liker95627062li_ker
linker104321472linker
locker124019422locker
mickey174211852mickey
mickler153310232mickler
milker124814322milker
mirker123712692mirker
mocker143315442mocker
mucker143816392mucker
necker124012792necker
nicer74618292nic_er
nicked135019682nicked
nickel123811342nickel
nickers134415092nickers
ocker113915752_ocker
packer144223402packer
pecker144615362pecker
picked154421312picked
pickeer153710112pickeer
pickers153718092pickers
picket144924312picket
pickier153912972pickier
piker115622842pi_ker
pinker125322442pinker
pricker154013412pricker
pucker143817632pucker
quicker2247022quicker
racker124824552racker
ricer74726612ric_er
richer114015042richer
ricked136523622ricked
rickey154613972rickey
risker105414492risker
rocker124319572rocker
sacker125124842sacker
shicker163914822shicker
sicked134524402sicked
sickee124622222sickee
sicken124615252sicken
siker95326032si_ker
sinker103620902sinker
slicker133314532slicker
snicker133012672snicker
sticker133515882sticker
sucker124120662sucker
tacker124224502tacker
thicker163611022thicker
ticked134720522ticked
tickers133617722tickers
ticket124524852ticket
tickler133612652tickler
tinker103619922tinker
tricker134615522tricker
tucker124316952tucker
wacker154920122wacker
whicker19359772whicker
wicked164317412wicked
wickers164114702wickers
wicket155318942wicket
winker134220292winker

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 Filter178691825510.343520965.0
2DLD Change Limit825511652.12338884.1
3Display Results1651650.0632619.0
 (SQL Overall)1786911652.52970656.8
 
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.