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

78 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
stubbily156424(None) 
stubbly1444471stubb_ly
chubbily2042912chubbily
grubbily1642972grubbily
scabbily1763942scabbily
scrubbily1842312scrubbily
shabbily1873902shabbily
snobbily1544232snobbily
stubbier1235352stubbier
stubbing13237452stubbing
stubble1136842stubb_le
stubby1345042stubb__y
stuffily17124162stuffily
sturdily1245082sturdily
bubbly124110353_bubb_ly
crabbily1744343crabbily
flabbily1843353flabbily
hubbly16478413_hubb_ly
nobbily1436693_nobbily
nubbly13369673_nubb_ly
rubbly133710613_rubb_ly
saucily1237913sau_cily
scummily1743303scummily
scurvily1643783scurvily
slubbing13248033slubbing
slushily1445013slushily
smudgily1543123smudgily
smuttily1344273smuttily
snubbier1244993snubbier
snubbing13236673snubbing
snubby1344533snubb__y
snuffily17124323snuffily
spunkily1733773spunkily
stabbing13238763stabbing
stabile9312063st_abile
stably113314123st_ab_ly
stagily1139053st_agily
stalkily1534823stalkily
steadily1236213steadily
steamily1335803steamily
stickily1736083stickily
stingily1236793stingily
stobbing13227243stobbing
stockily1735443stockily
stodgily1343903stodgily
stonily1049433st_onily
stormily1345243stormily
strobil936963strobil_
strobila1044933strobila
strobile1047033strobile
strobili1044933strobili
strobils1046563strobils
stubbed12378083stubb_ed
stubbiest1345483stubbiest
stubbled1385073stubbled
stubbles1236843stubbles
stubblier1343203stubblier
stubborn1242883stubborn
stubbornly175903stubbornly
studly10397693stu__dly
stultify1442723stultify
stumble1147553stumb_le
stupidly1442633stupidly
suably112814533s_uab_ly
subbing123915583s_ubbing
subfile122010503s_ubfile
subsidy1345973s_ubsidy
subtile91912623s_ubtile
subtilty1345453s_ubtilty
subtly11249263s_u_btly
sulkily14218113s_ulkily
sunnily1037833s_unnily
surlily10310003s_urlily
tubbier11237743_tubbier
tubbing123510093_tubbing
tubby124511403_tubb__y
tuftily1335573_tuftily
turbidly1443683_turbidly

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 Limit146162786.89021213.6
3Display Results78780.0332363.6
 (SQL Overall)178691787.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.