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

119 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
drabbest1329566(None) 
drabbet12319571drabbe_t
drabbets13294821drabbets
crabbiest1535622crabbiest
drabbed13428722drabbe_d
drabber12438592drabbe_r
drabbles13308522drabbles_
drabness1135802drabness
fabbest1438032_fabbest
grabbiest1435322grabbiest
rabbet103818652_rabbe_t
rabbets11279422_rabbets
abbes96723523__abbes_
abbess10509773__abbess
ablest84721833__ablest
arabesk1332863ara_besk
arables91814973arables_
arbalest1039523arbalest
babiest114414753_babiest
brabbles11349753brabbles_
braggest1296533braggest
brakiest143912243brakiest
brashest133511763brashest
bravest124211753bra_vest
brawest123810483bra_west
crabbed14388873crabbe_d
crabber133810733crabbe_r
crabbers14358753crabbers
crabmeat1445483crabmeat
crambes1339963crambes_
crankest1438143crankest
crassest103411523crassest
craziest19319923craziest
dabbed124416143d_abbe_d
dabber114816963d_abbe_r
dabbers123813213d_abbers
dabbles124514773d_abbles_
daftest11248943d_aftest
dampest12411043d_ampest
dankest122611673d_ankest
darbies104216983darbies_
darkest122512623d_arkest
darndest1067223darndest
daubes94913703d_aubes_
daubiest1138233daubiest
deadbeat1245803deadbeat
deadest93014883dea_dest
deafest112911513dea_fest
dearest83618673dea_rest
drabbing14286803drabbing
drabble12238883drabb_le
drabbled14367053drabbled
drabs85119673dra_b_s_
draffiest1644363draffiest
draftiest1335943draftiest
dragees9359483dragees_
draggiest12126413draggiest
dragnet91211433dragne_t
dragnets10136563dragnets
drakes114715863dra_kes_
drapes95419653dra_pes_
drawees11378363drawees_
drawliest13166243drawliest
dreamiest12227223dreamiest
dreariest10229123dreariest
drest65530343dr___est
dribbed13326753dribbe_d
dribbles13348393dribbles_
dribblet13347543dribblet
dribblets14294143dribblets
driblet103712243drible_t
driblets11266093driblets
driest74722753dr__iest
drollest937353drollest
drubbed13406983drubbe_d
drubber12357863drubbe_r
drubbers13386033drubbers
drumbeat1343973drumbeat
drunkest1334423drunkest
dryest104811123dr__yest
dumbest1238743d_umbest
durables11237013durables_
dwarfest1543473dwarfest
flabbiest1644203flabbiest
frailest1139493frailest
frankest1536963frankest
gabbiest1337273_gabbiest
gabfest1336453_gabfest
glibbest1343683glibbest
grabbed13368643grabbe_d
grabber12389763grabbe_r
grabbers13337883grabbers
grabbles13339893grabbles_
grandest10311573grandest
grapiest112211923grapiest
gravest114011633gra_vest
grayest11489363gra_yest
grubbiest1434253grubbiest
iratest7312483ira_test
orbiest9312413or_biest
rabbies113416053_rabbies_
rabbis102613163_rabbis_
rabbit102914563_rabb_it
rabbits11299863_rabbits
rabbles113517973_rabbles_
rabies85226023_rabies_
raciest92820013_raciest
rankest112713813_rankest
rarest65725483_ra_rest
rashest103916873_rashest
rawest93615063_ra_west
rebbes10313533_rebbes_
ribbiest1237583_ribbiest
rubiest92914423_rubiest
scabbiest1534913scabbiest
shabbiest1635323shabbiest
stablest103312943stablest
trapnest10310923trapnest
urbanest10117533urbanest

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.406440125.6
2DLD Change Limit1461621196.84321359.3
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.29524495.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.