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 “nickels” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

329 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
nickels1333865(None) 
nickel123811341nickel_
nickers134415091nickers
nickles133713821nickles
bickers154316552bickers
deckels14367362deckels
dickens144410132dickens
dickers144117662dickers
dickeys17479302dickeys
hickeys19508222hickeys
ickers123914182_ickers
kickers124013292kickers
knickers13306722knickers
lickers134118252lickers
mickeys18447942mickeys
mickles153415002mickles
neckers134210462neckers
nicely1139492nic_ely
niches114419142niche_s
nicked135019682nicke_d
nickeled15115512nickeled
nickelic1643272nickelic
nickelous1553412nickelous
nicker123818702nicke_r
nickle123814482nick_le
nickled144010442nickled
nicks114920492nick__s
nicols8810242nic_ols
pickers153718092pickers
pickets154314182pickets
pickles153215442pickles
rickets134915092rickets
rickeys16548982rickeys
sickees134514212sickees
sickens134411482sickens
sickles133417542sickles
snickers143010962snickers
tickers133617722tickers
tickets134113682tickets
tickles133416852tickles
wickers164114702wickers
wickets164010942wickets
ackees124914583_ackees
backers153821883backers
beckets15399823beckets
biceps12447713bic_eps
bices95029963bic_e_s
bicker144819173bicke_r
bikers124517553bi_kers
bikes117529473bi_ke_s
bilkers134711863bilkers
brickles162810283brickles
buckers153517453buckers
buckets153811693buckets
buckles153416093buckles
cackles153717203cackles
cels65534973__c_els
chickees19258513chickees
chickens19267433chickens
cicely1338833cic_ely
clickers163910203clickers
cockers153618333cockers
cockles153414643cockles
crickets16418123crickets
dackers143417043dackers
deckel134911043deckel_
deckers144413833deckers
deckles143312803deckles
dicers94720743dic_ers
dices86434243dic_e_s
dicked144920863dicke_d
dicker134521403dicke_r
dickey165913523dicke_y
dickies143416343dickies
dicks125824693dick__s
diesels8429143diesels
dikers114418793di_kers
dikes105831333di_ke_s
dinkeys15507263dinkeys
dispels10310503dispels
dockers143715003dockers
dockets144412243dockets
duckers143214713duckers
excels1536663exc_els
fices106031163fic_e_s
fiches145219533fiche_s
fickle153912973fick_le
fickler16348423fickler
ficklest17267903ficklest
fickly18318533fick_ly
ficoes114613463ficoe_s
flickers17338883flickers
fuckers163611593fuckers
gimels938893gi_mels
hackees165014103hackees
hackers164619043hackers
hackles162917063hackles
heckles163711383heckles
hickey185011993hicke_y
hickies163614743hickies
hicks145322173hick__s
hikers135014353hi_kers
hikes125426983hi_ke_s
hirsels10128343hirsels
hockers163915913hockers
hockeys19509273hockeys
huckles163612623huckles
ices66129643_ic_e_s
icker114018443_icke_r
ickily1535753_ickily
impels10389523_impels
inchers123912523inchers
inches114419673inche_s
inkers104018833_inkers
inkles103515653_inkles
jackals2036893jackals
jackers204214453jackers
jackets205011373jackets
jinkers183511813jinkers
jockeys23365953jockeys
keckles12318763keckles
kicked124415943kicke_d
kicker114116183kicke_r
kicks104420083kick__s
kickups1443503kickups
kikes85122553ki_ke_s
knackers13286843knackers
knockers13285733knockers
knuckles1384453knuckles
lackers134120543lackers
lackeys16458263lackeys
libels85112693li_bels
lichees123512783lichees
lichens123510683lichens
liches114724293liche_s
licked134621563licke_d
licker125222043licke_r
licks115325393lick__s
likely13328133li_kely
likens105613703li_kens
likers104620913li_kers
likes96231903li_ke_s
linkers114317713linkers
lintels73311163lintels
listels74212433listels
lockers133516923lockers
lockets134612203lockets
mackles154415753mackles
micell1098193mic_ell
micells11107683micells
miches134320733miche_s
mickey174211853micke_y
mickle143715133mick_le
mickler153310233mickler
micklest16219123micklest
micks135525373mick__s
mikes115129893mi_ke_s
milkers134411613milkers
minkes124618783minke_s
miskals13369763miskals
missels94614813missels
mockers153812943mockers
monickers1745083monickers
muckers153612803muckers
muckles153413253muckles
naches114622413nache_s
nacres85614453nacre_s
navels95712693n_avels
necked134715063necke_d
necker124012793necke_r
neckless14236433neckless
necks115119333neck__s
newels93710823n_ewels
nibbles114011693nibbles
nicads938333nic_ads
nice65534713nic_e__
niceness1039843niceness
nicer74618293nic_e_r
nicest82315663nic_est
nicety1138433nic_ety
niche105016793niche__
niched125514063niche_d
nick106627603nick___
nickeling1645393nickeling
nickelled1653793nickelled
nickered15117023nickered
nicking143516323nicking
nicol71113293nic_ol_
nides65229133ni_de_s
nidgets9358143nidgets
nieces84112713niece_s
nieves94311293nieve_s
niffers13287363niffers
niggers93111323niggers
niggles93512203niggles
nihils937573ni_hils
nills54926673ni__lls
nils46132453ni___ls
nines55937343ni_ne_s
nippers113012623nippers
nipples11319663nipples
niseis63512023ni_seis
niters64624213ni_ters
nites55736343ni_te_s
nitres65519333nitre_s
nitrils72810703nitrils
nixes124519623ni_xe_s
nixies135313873nixie_s
nocked134617383nocke_d
nocks115121013nock__s
noels56418703n__oels
novels95512503n_ovels
nuchals12216933nuchals
nucleus956573nucleus
nukes95418123n_uke_s
ockers123813903_ockers
packers153818893packers
packets155114773packets
peckers153312673peckers
picked154421313picke_d
pickeer153710113pickeer
pickeers16347243pickeers
picker144422173picke_r
pickerels1743723pickerels
picket144924313picke_t
pickle144215653pick_le
pickled164011883pickled
picks135226143pick__s
pickups1754253pickups
piculs103511753pic_uls
pikers124717393pi_kers
pikes115031033pi_ke_s
pinkens13419643pinkens
pinkers134118603pinkers
pinkeys16378213pinkeys
pixels15478533pi_xels
pockets154612253pockets
prickers163710673prickers
prickets16329083prickets
prickles162511093prickles
puckers153514673puckers
quickens2334253quickens
rackers134320453rackers
rackets134916873rackets
ricers84120993ric_ers
rices75536153ric_e_s
richens12349733richens
riches115022083riche_s
ricked136523623ricke_d
rickety16478313rickety
rickey154613973ricke_y
ricks115126133rick__s
ridgels9348023ridgels
riels55121333ri__els
riskers114011993riskers
rockers133916553rockers
rockets134615363rockets
ruckles133414603ruckles
sackers133820223sackers
shekels1436043shekels
shickers173012823shickers
sices75637273sic_e_s
sickbeds17254213sickbeds
sicked134524403sicke_d
sickee124622223sicke_e
sicken124615253sicke_n
sicker124023903sicke_r
sickerly1734033sickerly
sickest131813793sickest
sickies133717503sickies
sickle124418323sick_le
sickled144713433sickled
sickly153110483sick_ly
sickness1437833sickness
sickos125112033sick_os
sicks115127623sick__s
sikes96236083si_ke_s
simnels976103simnels
sinkers113618543sinkers
slickens14317263slickens
slickers143112553slickers
snackers143010223snackers
snicked143811633snicke_d
snicker133012673snicke_r
snickery17295543snickery
snicks124312473snick__s
snivels10336903sni_vels
snorkels1234413snorkels
sockets134012983sockets
stickers142913033stickers
stickles142512103stickles
suckers133717623suckers
suckles134516743suckles
tackers134319623tackers
tackets134914363tackets
tackles133816523tackles
thickens17266413thickens
thickets17287083thickets
ticals83214713tic_als
ticked134720523ticke_d
ticker124321503ticke_r
ticket124524853ticke_t
tickle124616743tick_le
tickled144313133tickled
tickler133612653tickler
ticklers14339303ticklers
ticks115823293tick__s
tikes95628903ti_ke_s
tinkers113517143tinkers
tinkles113713923tinkles
tinsels738373tinsels
trickers143812813trickers
trickles143013763trickles
tuckers134014353tuckers
tuckets134810333tuckets
vices105725533vic_e_s
wackes154717713wacke_s
whickers20297983whickers
wiches144418753wiche_s
wicked164317413wicke_d
wickedly2142793wickedly
wicker154518673wicke_r
wicket155318943wicke_t
wickless1736083wickless
wicks144619363wick__s
winkers143517113winkers
winkles143412773winkles
yikes125117753yi_ke_s
yokels13488063_yokels

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340273295.73623365.9
3Display Results3293290.1232674.8
 (SQL Overall)1786913296.26228535.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.