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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
sicklying194388(None) 
sickling152910331sickl_ing
nickling15278702nickl_ing
pickling17239202pickl_ing
sickening1635992sickening
sicking143720172sick__ing
stickling1647002stickl_ing
suckling152410022suckl_ing
tickling15309432tickl_ing
bickering1837663bickering
bricklaying2351833bricklaying
buckling17259113buckl_ing
cackling172610943cackl_ing
cockling172310393cockl_ing
dickering1737463dickering
dicking153617613dick__ing
duckling16247703duckl_ing
gillying13306813gi_llying
hackling183310163hackl_ing
heckling18257163heckl_ing
implying1635533_implying
inkling122911303_inkl_ing
inlying1168153_i_nlying
jockeying2663293jockeying
keckling14245523keckl_ing
kicking133314023kick__ing
lackeying1934923lackeying
licking144118283lick__ing
mackling172710063mackl_ing
mislying1437843mi_slying
nickeling1645393nickeling
nickelling1743643nickelling
nickering1636573nickering
nicking143516323nick__ing
pickaxing2543103pickaxing
picketing1835683picketing
picking163418333pick__ing
prickling1836533prickl_ing
ricking143920233rick__ing
rockling15259383rockl_ing
ruckling15258573ruckl_ing
sacking144122703sack__ing
sallying12309853s_allying
scalding12339393s_calding
scaling103519373s_cal_ing
scalping133410453s_calping
scolding12278913s_colding
scrying1338663s_c_rying
sculking15307913s_culking
sculling112910993s_culling
sculping13298943s_culping
shackling19286173shackl_ing
sibling10814423si_bl_ing
siccing12319513sic__cing
sicklied1546583sickl_ied
sicklier1457213sickl_ier
sicklies14710013sickl_ies
sicklily1744293sickl_ily
sickly153110483sickly___
sideling101012183sidel_ing
sidling9915423si_dl_ing
silking123715593si__lking
siloing83215503si__loing
silting83320483si__lting
singling101913003singl_ing
sinking123320543sink__ing
sizzling17225783sizzl_ing
skying14399983s__k_ying
slickening1743903slickening
slicking153712593slick__ing
snickering1744863snickering
snicking153610233snick__ing
socketing1666383socketing
socking143518603sock__ing
spackling18266503spackl_ing
speckling18235583speckl_ing
sticking153513463stick__ing
strickling1744953strickl_ing
suckering1638103suckering
sucking143217413suck__ing
sucklings16225113suckl_ings
sullying12328513s_ullying
supplying1774043supplying
tackling153211123tackl_ing
ticketing1635633ticketing
ticking143218753tick__ing
tinkling13239233tinkl_ing
trickling1647723trickl_ing
wicking173414773wick__ing
willying15306713wi_llying
winkling16298293winkl_ing

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641917.70319296.5
3Display Results91910.0303033.3
 (SQL Overall)178691917.88922650.7
 
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.