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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
scabbiest153491(None) 
shabbiest1635321shabbiest
cabbies133115162_cabbies_
cobbiest14118522_cobbiest
crabbiest1535622crabbiest
flabbiest1644202flabbiest
gabbiest1337272_gabbiest
grabbiest1435322grabbiest
scabbier1435132scabbie_r
scabbles14167982scabbles_
scabies11613332sca_bies_
scaliest101714392sca_liest
scantiest112611002scantiest
scariest101615942sca_riest
scarriest11188392scarriest
scattiest11268362scattiest
scrabbliest1742482scrabbliest
scrubbiest1643162scrubbiest
slobbiest1345082slobbiest
snobbiest1354962snobbiest
snubbiest1345072snubbiest
squabbiest2342852squabbiest
stubbiest1345482stubbiest
swabbies15115712swabbies_
babiest114414753_ba_biest
cabbie122913353_cabbie__
cagiest102916433_ca_giest
cakiest133215663_ca_kiest
cambist13312113_cambi_st
campiest142212133_campiest
canniest10313363_canniest
cattiest103016333_cattiest
chubbiest1843753chubbiest
clubbiest1534273clubbiest
cubbies133312883_cubbies_
daubiest1138233_daubiest
drabbest13295663drabb_est
fabbest1438033_fabb_est
globbiest1444023globbiest
grubbiest1434253grubbiest
knobbiest1752883knobbiest
knubbiest1752623knubbiest
lambiest122410183_lambiest
nobbiest12117773_nobbiest
nubbiest12117313_nubbiest
rabbies113416053_rabbies_
ribbiest1237583_ribbiest
saggiest102812713s_aggiest
sagiest82617983s_a_giest
saltiest83117713s_altiest
sandiest93218683s_andiest
sappiest122612573s_appiest
sarkiest123615063s_arkiest
sassiest83413613s_assiest
sauciest10310973s_auciest
savviest1435983s_avviest
scabbed14408223scabb_e_d
scabbily1763943scabbi_ly
scabbing15277193scabbi_ng
scabble13168653scabble__
scabbled15156303scabble_d
scabiosa1262853sca_biosa
scampies1439323scampies_
scantest101710183sca_ntest
scanties103215423scanties_
scarcest12169173sca_rcest
scaredest1246633scaredest
schiziest2343913schiziest
scrabbles15206283scrabbles_
scraggiest1444363scraggiest
scrappiest1644153scrappiest
scrawliest1553813scrawliest
scrawniest1543483scrawniest
screwiest1445473screwiest
scummiest1535213scummiest
scurfiest14236863scurfiest
scurviest14266123scurviest
scuzziest1943003scuzziest
seamiest102715413sea_miest
shabbier1535183shabbie_r
shabbiness1743133shabbiness
shadiest121711273sha_diest
shaggiest14156893shaggiest
shakiest151910933sha_kiest
shaliest111415053sha_liest
shrubbiest1742353shrubbiest
skankiest12145703skankiest
slaggiest11157703slaggiest
slangiest10129073slangiest
slatiest82616263sla_tiest
smarmiest1335903smarmiest
snaggiest11126673snaggiest
snakiest122110543sna_kiest
snappiest1346493snappiest
snarkiest13207633snarkiest
snarliest91810203snarliest
snazziest1743133snazziest
soapiest102412843soa_piest
spaciest122310893spa_ciest
sparkiest15188093sparkiest
sparriest11198783sparriest
stablest103312943sta_blest
staggiest11148253staggiest
stagiest91613403sta_giest
stalkiest1347903stalkiest
starriest9159763starriest
stubbliest1453343stubbliest
swabbie1484333swabbie__
swampiest1635023swampiest
swankiest16136203swankiest
tabbies112913503_tabbies_
tubbiest12117293_tubbiest
wabbliest16274963_wabbliest
webbiest1535353_webbiest
yabbies14279643_yabbies_

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.436409841.7
2DLD Change Limit1486411156.92321470.6
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.40524131.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.