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

68 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
stubblier134320(None) 
stubbier1235351stubb_ier
bubblier1184472_bubblier
nubblier1254412_nubblier
rubblier1244912_rubblier
snubbier1244992snubb_ier
stubble1136842stubbl_e_
stubbled1385072stubbl_ed
stubbles1236842stubbl_es
stubbliest1453342stubbliest
studlier935472stu_dlier
stumbler1235812stumbl_er
tubbier11237742_tubb_ier
bubbler103611783_bubbl_er
bubblies1166773_bubblies
burblier1255603_burblier
chubbier1733893chubb_ier
clubbier1434833clubb_ier
crumblier1543873crumblier
grubbier13344753grubb_ier
knobblier1741923knobblier
knubbier1642513knubb_ier
nubbier11308133_nubb_ier
pebblier1453263_pebblier
scabbier1435133scabb_ier
scrabblier1642773scrabblier
scrubbier1543333scrubb_ier
shabbier1535183shabb_ier
shrubbier1642193shrubb_ier
slobbier1254633slobb_ier
slubber113010763slubb__er
snobbier1234633snobb_ier
snubber11277733snubb__er
snufflier1543303snufflier
squabbier2242753squabbier
squabbler2242733squabbl_er
squallier1844363squallier
stabber113610153stabb__er
stabilizer21124643stabilizer
stabler94014933st_abl_er
statelier945653statelier
steelier839193st_eelier
stillier868823st_illier
stubbed12378083stubb__ed
stubbiest1345483stubb_iest
stubbily1564243stubb_ily
stubbing13237453stubb_ing
stubbly1444473stubbl__y
stubborner1451683stubborner
studier82510053stu__dier
stuffier14336623stu_ffier
stumble1147553stumbl_e_
stumbled1335623stumbl_ed
stumblers1334383stumbl_ers
stumbles1237493stumbl_es
stumbling1435003stumbling
stumpier1255883stu_mpier
stupefier1442653stupefier
sturdier9216963stu_rdier
sublimer1237613s_u_blimer
subtiler10208573s_ubtiler
subtler92910843s_ubtl_er
supplier1246603s_upplier
surlier72915443s_u_rlier
tubber104313203_tubb__er
tumbler113412823_tumbl_er
wabblier15375493_wabblier
wobblier15325203_wobblier

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.453394461.4
2DLD Change Limit148641687.33020278.4
3Display Results68680.0302266.7
 (SQL Overall)178691687.81322871.0
 
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.