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

128 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
kicker11411618(None) 
bicker144819171bicker
dicker134521401dicker
icker114018441_icker
kicked124415941kicked
kickers124013291kickers
kickier12349051kickier
licker125222041licker
nicker123818701nicker
picker144422171picker
sicker124023901sicker
ticker124321501ticker
wicker154518671wicker
backer144525522backer
bickers154316552bickers
biker116022562bi_ker
bilker124913442bilker
bucker145420462bucker
clicker154111882clicker
cocker144320392cocker
dacker134920752dacker
decker135215992decker
dicer85426422dic_er
dicier94416232dicier
dicked144920862dicked
dickers144117662dickers
dickey165913522dickey
dickier143512452dickier
diker105524552di_ker
docker134417652docker
ducker134317992ducker
fickler16348422fickler
flicker163610622flicker
fucker153414422fucker
hacker154822692hacker
hickey185011992hickey
hiker125119392hi_ker
hocker155118562hocker
icier74313752_icier
ickers123914182_ickers
ickier12439922_ickier
inker94421092_inker
jacker194417582jacker
jinker174013542jinker
kecked125113172kecked
kick96026062kick__
kicks104420082kick_s
kickup1354132kickup
kicky135012332kick_y
kidder123811102kidder
kier86526802ki__er
kike76524782ki_ke_
kikes85122552ki_kes
killer104917952killer
kilter103714342kilter
kinder113716842kinder
kinked104014752kinked
kinkier10319432kinkier
kipper143414212kipper
kisser104212452kisser
kiter95523212ki_ter
knacker12307912knacker
knickers13306722knickers
knocker12296392knocker
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
skinker10319442skinker
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 Limit825511282.45333653.1
3Display Results1281280.0333878.8
 (SQL Overall)1786911282.82963164.0
 
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.