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

144 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
sickener143660(None) 
sickened1546781sickened
sickeners1535731sickeners
slickener1544041slickener
bickerer16106772bickerer
pickeer153710112picke_er
picketer16187432picketer
quickener2443122quickener
sickee124622222sicke_e_
sickees134514212sicke_es
sicken124615252sicken__
sickens134411482sicken_s
sicker124023902sick__er
sicklier1457212sicklier
slackener1543932slackener
slickened1644292slickened
slickeners1643662slickeners
snickerer15134562snickerer
thickener1844162thickener
wickeder1843982wickeder
awakener1543433awakener
beckoner1654963beckoner
bicker144819173bick__er
bickered17108003bickered
bickerers17115593bickerers
blackener1754973blackener
chickened2144623chickened
cricketer1744563cricketer
darkener1335993darkener
dickens144410133dicken_s
dickenses1645073dickenses
dicker134521403dick__er
dickered16117533dickered
dickier143512453dick_ier
fickler16348423fick_ler
harkener1537573harkener
icker114018443_ick__er
ickier12439923_ick_ier
kicker114116183kick__er
kickier12349053kick_ier
licencer12146133lic_encer
licenser10155883lic_enser
lichened1435753lichened
licker125222043lick__er
likened12267353li_kened
listener8158313listener
livener10278943li_vener
mickler153310233mick_ler
nickeled15115513nickeled
nicker123818703nick__er
nickered15117023nickered
pickeers16347243picke_ers
picker144422173pick__er
pickerel1645273pickerel
picketed17167383picketed
picketers17196483picketers
pickier153912973pick_ier
pilsener1044753pilsener
pinkened1535753pinkened
pocketer16157373pocketer
puckerer1645793puckerer
quickened2543163quickened
quickeners2542763quickeners
reckoner1446063reckoner
richened1435953richened
ricketier15134583ricketier
ripener937903ri_pener
rocketer14158333rocketer
sacker125124843sack__er
scanner94411813s_canner
scene77220573s_c_ene_
scenery1236563s_c_enery
scenes84520353s_c_enes
schemer1477963s_chemer
scorner9259763s_corner
screener1037573screener
screwer124410073s_crewer
scunner9358243s_cunner
seceder10329573sec_eder
secreter1038513secreter
serener73415763s_erener
shicker163914823shick__er
shickered19115723shickered
sickbed16396823sick_bed
sicked134524403sick__ed
sickening1635993sickening
sickerly1734033sickerly
sickest131813793sicke_st
sickie123715743sick_ie_
sickies133717503sick_ies
sicking143720173sickin_g
sickle124418323sick_le_
sickled144713433sick_led
sickles133417543sick_les
sicklied1546583sicklied
sicklies14710013sicklies
sickness1437833sickness
signer74015633si__gner
siker95326033si_k__er
silencer1036293si_lencer
silenter838873si_lenter
silken104410853silken__
silkier114411643silk_ier
silverer11216733silverer
simperer1237173simperer
sincerer1037203sincerer
sinker103620903sink__er
sinner64320603si__nner
skene96118123s__kene_
skenes104616633s__kenes
skewer13519613s__kewer
slackened1644243slackened
slackeners1643423slackeners
slicken13309293slicken__
slickens14317263slicken_s
slicker133314533slick__er
slickster1543413slickster
snicker133012673snick__er
snickered16115343snickered
snickerers16133583snickerers
socketed15177343socketed
sockeye1666413sockeye_
sockeyes1765763sockeyes
softener1145613softener
sticker133515883stick__er
stickier14229763stick_ier
stickler14259573stick_ler
stiffener1541963stiffener
sucker124120663suck__er
suckered1537833suckered
suckier133613973suck_ier
suckler133413093suck_ler
sullener857243sullener
thickened1944303thickened
thickeners1943463thickeners
ticker124321503tick__er
ticketed15146643ticketed
tickler133612653tick_ler
tinkerer1286803tinkerer
wakener1446913_wakener
weakener1534913weakener
wicker154518673wick__er
widener11318693wi_dener
wiener94513543wi__ener

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621446.51622431.2
3Display Results1441440.0602400.0
 (SQL Overall)1786911446.99925530.9
 
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.