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

80 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
smirkily175333(None) 
mirkily16266401_mirkily
milkily16216552_milkily
murkily16287112_murkily
quirkily2442592quirkily
silkily14236962s_ilkily
slinkily1534852slinkily
smarmily1543522smarmily
smirkier1444432smirkier
smirking15277232smirking
smirky15406942smirk__y
smokily1635372sm_okily
snarkily1534582snarkily
sparkily1735022sparkily
spikily1635872spi_kily
stickily1736082stickily
airily93014823_air_ily
chirpily1843773chirpily
dirtily1138583_dirtily
friskily1834503friskily
ickily1535753__ickily
jerkily2134623_jerkily
kinkily1335223_kinkily
merrily1238633_merrily
mirkier13319053_mirkier
mirky146315523_mirk__y
mistily122612343_mistily
muckily18277743_muckily
murkly15368303_murk_ly
muskily16289043_muskily
perkily1637813_perkily
riskily1436413_riskily
scarily12311703scar_ily
scurvily1643783scurvily
shakily1736903s_hakily
shiftily1744553shiftily
shinily13268933shi_nily
shirking163210473shirking
sicklily1744293s_icklily
sickly153110483s_ick_ly
sillily10209783s_illily
skimpily1963053skimpily
slickly1635853slick_ly
slimily1247713sli_mily
slippily1544193slippily
smartly12497433smar_tly
smerking15258473smerking
smirk116612753smirk___
smirked14307233smirk_ed
smirker13327423smirk_er
smirkers14316353smirkers
smirkiest1535193smirkiest
smirks124910123smirk__s
smudgily1543123smudgily
smuttily1344273smuttily
snakily1436913s_nakily
sneakily1544423sneakily
sniffily17154033sniffily
snippily1543573snippily
sorrily1039833s_orrily
sparkly16348133spark_ly
spicily1438653spi_cily
spiffily19153483spiffily
spirally1348023spirally
spookily1744173spookily
sportily1337733sportily
spunkily1733773spunkily
stalkily1534823stalkily
starkly14277033stark_ly
stingily1236793stingily
stockily1735443stockily
stormily1345243stormily
sturdily1245083sturdily
sulkily14218113s_ulkily
surlily10310003s_urlily
swankily1833833swankily
swimmily1842713swimmily
swirly12439253swir__ly
trickily1736233trickily
wirily123310783_wir_ily

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.440406115.9
2DLD Change Limit146162807.33019940.2
3Display Results80800.0302666.7
 (SQL Overall)178691807.80022909.1
 
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.