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

433 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
dickens14441013(None) 
dickers144117661dickers
dickeys17479301dickeys
sickens134411481sickens
bickers154316552bickers
chickens19267432chickens
dackers143417042dackers
darkens12409872darkens
deckels14367362deckels
deckers144413832deckers
dicers94720742dic_ers
dices86434242dic_e_s
dicked144920862dicke_d
dickenses1645072dickenses
dicker134521402dicke_r
dickey165913522dicke_y
dickies143416342dickies
dicking153617612dicking
dicks125824692dick__s
dikers114418792di_kers
dikes105831332di_ke_s
dinkeys15507262dinkeys
dizens164911392di_zens
dockers143715002dockers
dockets144412242dockets
duckers143214712duckers
hickeys19508222hickeys
ickers123914182_ickers
kickers124013292kickers
lichens123510682lichens
lickers134118252lickers
likens105613702li_kens
mickeys18447942mickeys
nickels13338652nickels
nickers134415092nickers
pickers153718092pickers
pickets154314182pickets
pinkens13419652pinkens
quickens2334252quickens
richens12349732richens
rickets134915092rickets
rickeys16548982rickeys
sickees134514212sickees
sicken124615252sicken_
slickens14317262slickens
thickens17266412thickens
tickers133617722tickers
tickets134113682tickets
wickers164114702wickers
wickets164010942wickets
ackees124914583_ackees
awakens14416153awakens
backers153821893backers
beckets15399823beckets
beckons15279143beckons
biceps12447713bic_eps
bices95029963bic_e_s
bicker144819173bicke_r
bicorns11338763bicorns
bicrons113410473bicrons
bikers124517553bi_kers
bikes117529473bi_ke_s
bilkers134711863bilkers
biogens1038963biogens
blackens16388103blackens
brackens16327923brackens
buckeens1634853buckeens
buckers153517453buckers
buckets153811693buckets
chickees19258513chickees
chicken18278983chicken_
clickers163910203clickers
cockers153618333cockers
crickets16418123crickets
daces85030683dac_e_s
dacker134920753dacke_r
dacrons103211033dacrons
daikers124010313daikers
daikons12186693daikons
dampens12348563dampens
darken114013443darken_
darkeys15356533darkeys
davens104612913d_avens
deadens93410693deadens
deafens11317253deafens
decanes103118913decanes
decent94023703dec_ent
decerns10119053decerns
decked145217623decke_d
deckel134911043decke_l
decker135215993decke_r
decking153915593decking
deckings16346683deckings
deckles143312803deckles
decks124822193deck__s
decrees102513123decrees
deepens10307813deepens
deicers103612733deic_ers
deices94119373deic_e_s
dekes105224453d_eke_s
dens55945073d___ens
detickers1634423detickers
diadems1135393diadems
dialers83614303dialers
diamins10312213diamins
diapers104713913diapers
diazins1739183diazins
dibbers124013173dibbers
dicasts1078703dicasts
dice75841903dic_e__
diced95824683dic_e_d
dicer85426423dic_e_r
dicey114819333dic_e_y
dicier94416233dicie_r
diciest103316523diciest
dicing105718763dic_ing
dick116432393dick___
dickered16117533dickered
dickering1737463dickering
dickhead1944143dickhead
dickheads2043633dickheads
dickie133913113dick_ie
dickier143512453dickier
dickiest153412503dickiest
dicky154816243dick__y
dicliny1337673dicliny
dicots94915793dic_ots
dictions111812673dictions
dictums1235553dictums
didies84621833didie_s
didoes85716963didoe_s
diene65720133di__ene
dienes75719903di__enes
dies55653533di__e_s
diesels8429143diesels
dieses75218693diese_s
dieters83216433dieters
diets66026643di__ets
differs14339973differs
diggers104413393diggers
digress938323digress
dike95935773di_ke__
diked115024683di_ke_d
diker105524553di_ke_r
dikey135116423di_ke_y
diking124320243di_king
diluent8310263diluent
diluents946063diluents
dimers94321093di_mers
dimes85833043di_me_s
dimmers123811563dimmers
dimness1038843dimness
diners75525953di_ners
dines66449153di_ne_s
dingers94321383dingers
dinges83825423dinge_s
dingeys12458403dingeys
dinked124818353dinke_d
dinkey144812763dinke_y
dinkies123716033dinkies
dinking133618283dinking
dinks105927953dink__s
dinkums1433673dinkums
dinners83915443dinners
dins56652053di___ns
diodes83915783diode_s
dioxans1555313dioxans
dioxins1568003dioxins
dipnets10109033dipnets
dippers123615183dippers
dirges84915103dirge_s
dirked124912273dirke_d
dirking133812603dirking
dirks105619523dirk__s
discerns1138163discerns
dishes104622653dishe_s
disked125015763diske_d
disking134615493disking
disks105417473disk__s
dismes95617673disme_s
disowns1136733disowns
dispels10310503dispels
dispend11289413dispend
dispends12308533dispends
dispense11129783dispense
dissent84018683dissent
dissents93411863dissents
disses75225963disse_s
distend93312073distend
distends10339823distends
distent84120853distent
ditchers143610363ditchers
ditches133215713ditche_s
dites66339153di_te_s
dithers114016153dithers
ditzes163212423ditze_s
diurons838823diurons
divans104612393di_vans
divers105024963di_vers
dives95832403di_ve_s
divines113514723divines
diwans105110373di_wans
dizen155214933di_zen_
docent92918683doc_ent
docents102810803doc_ents
docked145018333docke_d
docker134417653docke_r
docket134721173docke_t
docking153615013docking
docks126022313dock__s
dolmens10388693dolmens
donkeys15426663donkeys
dovens104413903d_ovens
doyens104810223d_oyens
dozens164612463d_ozens
drakes114715863drake_s
drinkers13277823drinkers
duces86327473duc_e_s
duchess1335553duchess
ducked144718013ducke_d
ducker134317993ducke_r
duckies143613813duckies
ducking154315053ducking
duckpins1743693duckpins
ducks124823213duck__s
dudeens934863dudeens
duikers12369383duikers
dukes105023473d_uke_s
dunkers123512193dunkers
dykes135215573d_yke_s
eikons1038503ei_kons
fices106031163fic_e_s
fiches145219533fiche_s
ficins113513983fic_ins
ficoes114613463ficoe_s
firkins1437663firkins
flickers17338883flickers
fuckers163611593fuckers
givens10379733gi_vens
hackees165014103hackees
hackers164619043hackers
harkens144112863harkens
hickey185011993hicke_y
hickies163614743hickies
hicks145322173hick__s
hikers135014353hi_kers
hikes125426983hi_ke_s
hockers163915913hockers
hockeys19509273hockeys
ices66129643_ic_e_s
icker114018443_icke_r
icones84616383_icones
icons76516493_ic_ons
ikons96311013_i_kons
inkers104018833_inkers
jackers204214453jackers
jackets205011373jackets
jinkers183511813jinkers
jockeys23365953jockeys
kens85435253___kens
kicked124415943kicke_d
kicker114116183kicke_r
kicking133314023kicking
kicks104420093kick__s
kickups1443503kickups
kikes85122563ki_ke_s
kitchens17195783kitchens
kittens11347583kittens
knickers13306723knickers
krakens1034293krakens
kuchens1634713kuchens
lackers134120543lackers
lackeys16458263lackeys
license9148423lic_ense
lichees123512783lichees
lichen114012743lichen_
liches114724293liche_s
licked134621563licke_d
licker125222043licke_r
licking144118283licking
lickings15298143lickings
licks115325393lick__s
liens56525503li__ens
liken911818843li_ken_
likers104620913li_kers
likes96231903li_ke_s
limens84618033li_mens
lindens839413lindens
linens64818393li_nens
linkers114317713linkers
lippens11328533lippens
listens74014133listens
livens94314893li_vens
lockers133516923lockers
lockets134612203lockets
miches134320733miche_s
mickey174211853micke_y
mickles153415003mickles
micks135525373mick__s
microns113814783microns
middens11379383middens
miens76118303mi__ens
mikes115129893mi_ke_s
mildens10339933mildens
milkers134411613milkers
minkes124618783minke_s
mispens11311073mispens
mittens9349883mittens
mizens174610253mi_zens
mizzens17366123mizzens
mockers153812943mockers
muckers153612803muckers
neckers134210463neckers
niches114419143niche_s
nicked135019683nicke_d
nickel123811343nicke_l
nicker123818703nicke_r
nicking143516323nicking
nickles133713823nickles
nicks114920493nick__s
ockers123813903_ockers
packers153818893packers
packets155114773packets
peckers153312673peckers
pectens11189203pectens
picked154421313picke_d
pickeer153710113pickeer
pickeers16347243pickeers
picker144422173picke_r
picket144924313picke_t
picking163418333picking
pickings17359383pickings
pickles153215443pickles
picks135226143pick__s
pickups1754253pickups
pigpens1235503pigpens
pikers124717393pi_kers
pikes115031033pi_ke_s
pinken124513283pinken_
pinkers134118603pinkers
pinkeys16378213pinkeys
pipkins15328183pipkins
pockets154612253pockets
prickers163710673prickers
prickets16329083prickets
puckers153514673puckers
quicken2235153quicken_
rackers134320453rackers
rackets134916873rackets
reckons13269653reckons
ricers84120993ric_ers
rices75536153ric_e_s
richen113812513richen_
riches115022083riche_s
ricins83618703ric_ins
ricked136523623ricke_d
rickety16478313rickety
rickey154613973ricke_y
ricking143920233ricking
ricks115126133rick__s
ripens85012173ri_pens
riskers114011993riskers
rockers133916553rockers
rockets134615363rockets
sackers133820223sackers
shickers173012823shickers
sices75637273sic_e_s
sickbeds17254213sickbeds
sicked134524403sicke_d
sickee124622223sicke_e
sickened1546783sickened
sickener1436603sickener
sickeners1535733sickeners
sicker124023903sicke_r
sickest131813793sickest
sickies133717503sickies
sicking143720173sicking
sickles133417543sickles
sickness1437833sickness
sickos125112033sick_os
sicks115127623sick__s
siemens938413siemens
sikes96236083si_ke_s
silken104410853silken_
sinkers113618543sinkers
sirens65318153si_rens
siskins1159583siskins
sithens1039383sithens
slackens14367713slackens
slicken13309293slicken_
slickers143112553slickers
snickers143010963snickers
sockets134012983sockets
stickers142913033stickers
suckers133717623suckers
tackers134319623tackers
tackets134914363tackets
thicken16317873thicken_
thickets17287083thickets
ticked134720523ticke_d
ticker124321503ticke_r
ticket124524853ticke_t
ticking143218753ticking
tickings15368583tickings
ticklers14339303ticklers
tickles133416853tickles
ticks115823293tick__s
tikes95628903ti_ke_s
tinkers113517143tinkers
tokens104711563_tokens
trickers143812813trickers
tuckers134014353tuckers
tuckets134810333tuckets
vices105725533vic_e_s
vixens16286203vi_xens
wackes154717713wacke_s
wakens135012043_wakens
weakens14367063weakens
whickers20297983whickers
wiccans1434603wiccans
wiches144418753wiche_s
wicked164317413wicke_d
wicker154518673wicke_r
wicket155318943wicke_t
wicking173414773wicking
wickings18357183wickings
wickless1736083wickless
wicks144619363wick__s
widens106212723wi_dens
winkers143517113winkers
wizens186110263wi_zens
wizzens18385483wizzens
yikes125117753yi_ke_s

Search took 8 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.390458182.1
2DLD Change Limit1340274336.83019623.3
3Display Results4334330.1532830.1
 (SQL Overall)1786914337.37324235.9
 
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.