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

136 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
nicker12381870(None) 
bicker144819171bicker
dicker134521401dicker
icker114018441_icker
kicker114116181kicker
licker125222041licker
necker124012791necker
nicer74618291nic_er
nicked135019681nicked
nickel123811341nickel
nickers134415091nickers
picker144422171picker
sicker124023901sicker
snicker133012671snicker
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
incher114114032incher
inker94421092_inker
jacker194417582jacker
jinker174013542jinker
kicked124415942kicked
kickers124013292kickers
kickier12349052kickier
knacker12307912knacker
knickers13306722knickers
knocker12296392knocker
lacker125325622lacker
licked134621562licked
lickers134118252lickers
liker95627062li_ker
linker104321472linker
locker124019422locker
mickey174211852mickey
mickler153310232mickler
milker124814322milker
mirker123712692mirker
mocker143315442mocker
monicker1635732monicker
mucker143816392mucker
necked134715062necked
neckers134210462neckers
nice65534712nic_e_
niche105016792niche_
niched125514062niched
niches114419142niches
nick106627602nick__
nickels13338652nickels
nickered15117022nickered
nickle123814482nickle
nickled144010442nickled
nickles133713822nickles
nicks114920492nick_s
niffer12378442niffer
nigger89713572nigger
nigher103612752nigher
nipper103715712nipper
niter55028972ni_ter
nocked134617382nocked
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
snacker133112602snacker
snicked143811632snicked
snickers143010962snickers
snickery17295542snickery
sticker133515882sticker
sucker124120662sucker
tacker124224502tacker
thicker163611022thicker
ticked134720522ticked
tickers133617722tickers
ticket124524852ticket
tickler133612652tickler
tinker103619922tinker
tricker134615522tricker
tucker124316952tucker
unsicker1435302unsicker
wacker154920122wacker
whicker19359772whicker
wicked164317412wicked
wickers164114702wickers
wicket155318942wicket
winker134220292winker

Search took 4 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.423422437.4
2DLD Change Limit825511362.95327955.0
3Display Results1361360.0462956.5
 (SQL Overall)1786911363.42252218.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.