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

65 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
sticklike144400(None) 
bricklike1643112bricklike
sacklike1337302s_acklike
silklike1135522s_ilklike
stalklike1243902stalklike
stickle132410972stickl__e
stickling1647002stickling
clocklike1642823clocklike
cocklike1536733_cocklike
disklike12206743_disklike
epiclike1644143epic_like
icelike1337173__icelike
inklike1037033__inklike
necklike13104563_necklike
ostrichlike2051073ostrichlike
quicklime2641823quicklime
rocklike1335903_rocklike
saclike131210123s_ac_like
saintlike1344783saintlike
sharklike1543933sharklike
sickie123715743s_ick_i_e
sickle124418323s_ickl__e
sicklied1546583s_icklied
sicklier1457213s_icklier
sicklies14710013s_icklies
sicklily1744293s_icklily
sickling152910333s_ickling
sighlike1635533s_ighlike
skinlike1134873ski_nlike
skirtlike1243003skirtlike
slitlike1235303sli_tlike
spikelike14103873spikelike
spinelike1585353spinelike
stagelike1445343stagelike
stairlike1344753stairlike
starlike1238813st_arlike
steedlike1443653steedlike
stemlike1436723st_emlike
steplike1436733st_eplike
stickable1745543stickable
stickier14229763stick_ier
stickies142211973stick_ies
stickily1736083stick_ily
sticking153513463stick_ing
stickit1339463stick_i_t
stickled15298973stickl_ed
stickler14259573stickl_er
sticklers15227393sticklers
stickles142512103stickl_es
stickpin1643763stickpi_n
stickpins1744093stickpins
stockpile1743033stockpile
strickle1467793strickl__e
strickling1744953strickling
suchlike1735123s_uchlike
suitlike1236313sui_tlike
tanklike1136013_tanklike
tickle124616743_tickl__e
tickling15309433_tickling
ticklish1755283_ticklish
tidelike1336743_tidelike
tilelike1237053_tilelike
tinlike11248803_ti_nlike
tusklike1133583_tusklike
witchlike2143103witchlike

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.423422437.4
2DLD Change Limit148641656.89021573.4
3Display Results65650.0331969.7
 (SQL Overall)178691657.34624324.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.