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

120 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
strickled166583(None) 
stickled15298971st_ickled
strickle1467791strickle_
strickles1567811strickles
trickled152610431_trickled
prickled17358072_prickled
sickled144713432s__ickled
sprinkled1633712sprinkled
sticked144114632st_ick_ed
stickle132410972st_ickle_
stickler14259572st_ickler
stickles142512102st_ickles
stricken1436892strick_en
tickled144313132_t_ickled
tricked144016162_trick_ed
trickle133613442_trickle_
trickles143013762_trickles
truckled15327312_truckled
articled1137063artic_led
astricted1247443astric_ted
auricled11135703auric_led
bricked164312063_brick_ed
brickle15279933_brickle_
brickles162810283_brickles
crackled17428863_crackled
cricked164814283_crick_ed
crinkled15357153_crinkled
freckled18104443_freckled
nickled144010443__nickled
pickled164011883__pickled
pricked164613833_prick_ed
prickle153611013_prickle_
prickles162511103_prickles
ricked136523623__rick_ed
ruckled144111033__ruckled
scribbled16174033scribbled
shackled18277603s_hackled
shrieked16265173shriek_ed
shrilled1246863shri_lled
shriveled1643153shriveled
sickbed16396823s__ickbed
sicked134524403s__ick_ed
sickle124418323s__ickle_
sickles133417543s__ickles
sicklied1546583s__icklied
slicked144413843s_lick_ed
snicked143811633s_nick_ed
spackled17297803s_packled
speckled17255833s_peckled
sprinkle1434893sprinkle_
sprinkler1543573sprinkler
sprinkles1534933sprinkles
stacked143416123st_ack_ed
stenciled1243963stenciled
sticker133515883st_ick_er
stickier14229763st_ickier
stickies142211973st_ickies
sticklers15227393st_icklers
stickmen1634543st_ickmen
stickseed1683483st_ickseed
stickweed1983383st_ickweed
stifled113511093st_i_fled
stilled83314793st_i_lled
stippled1345303st_ippled
stipuled1134453st_ipuled
stocked144312873st_ock_ed
straddled12205023straddled
straggled12296853straggled
straked125415343str_ak_ed
strangled11268983strangled
streaked13228453streak_ed
streeked13246153streek_ed
streeled9267873str_eeled
striated93414153stri_ated
strick124813203strick___
strickling1744953strickling
stricks134310693strick__s
stricter1039423stric_ter
strictly1345813strictl_y
strike105619733stri_k_e_
striker113714173stri_k_er
strikes114719093stri_k_es
stringed102911873stri_nged
striped105214363stri__ped
stripped1357093stri_pped
strived114713663stri__ved
stroked124613623str_ok_ed
strolled937823str_olled
strucken1444323struck_en
struggled12304303struggled
suckled144212513s__uckled
tackled143913193_t_ackled
ticked134720523_t_ick_ed
tickle124616743_t_ickle_
tickler133612653_t_ickler
tickles133416853_t_ickles
tinkled123910473_t_inkled
trachled1438313_trachled
tracked143716133_track_ed
triced95518673_tric__ed
tricker134615523_trick_er
trickie132611033_trickie_
trickier143010233_trickier
tricklier15256823_tricklier
trickly16369893_trickl_y
triclad1037443_tric_lad
trifled113711963_tri_fled
trilled84116313_tri_lled
trindled10388693_trindled
tripled104113833_tri_pled
trocked144312243_trock_ed
trucked143910813_truck_ed
truckle13358863_truckle_
truckler14297453_truckler
truckles14319383_truckles
twinkled1663943_twinkled
utricle937913utric_le_
utricles1037223utric_les
wricked174910193_wrick_ed
wrinkled16275353_wrinkled

Search took 10 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411208.59617291.9
3Display Results1201200.0462608.7
 (SQL Overall)1786911209.06219718.7
 
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.