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

123 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
drabbets1329482(None) 
drabbest13295661drabbest
drabbet12319571drabbet_
rabbets11279421_rabbets
crabbers14358752crabbers
dabbers123813212d_abbers
drabbed13428722drabbe_d
drabber12438592drabbe_r
drabbles13308522drabbles
drabness1135802drabness
dragnets10136562dragnets
dribblets14294142dribblets
driblets11266092driblets
drubbers13386032drubbers
grabbers13337882grabbers
rabbet103818652_rabbet_
rabbits11299862_rabbits
abbes96723523__abbe_s
abbess10509773__abbess
abbeys13538423__abbeys
abbots1039283__abbots
abets75621673__a_bets
arables91814973arable_s
barbets114915843_barbets
blabbers11308153blabbers
brabblers12335563brabblers
brabbles11349753brabbles
brachets154311983brachets
brackets163310433brackets
cablets114216343_cablets
clabbers14359903clabbers
crabbed14388873crabbe_d
crabber133810733crabbe_r
crabbiest1535623crabbiest
crabmeats1542993crabmeats
crambes1339963crambe_s
cribbers14306443cribbers
dabbed124416143d_abbe_d
dabber114816963d_abbe_r
dabblers13379363d_abblers
dabbles124514773d_abbles
darbies104216983darbie_s
daubers104610423d_aubers
daubes94913703d_aube_s
daybeds14234473d_aybeds
deadbeats1343683deadbeats
diabetes1147023dia_betes
dibbers124013173d_ibbers
dobbers123513253d_obbers
doublets11257363doublets
drabbing14286803drabbing
drabble12238883drabb_le
drabbled14367053drabbled
drabs85119673dra_b__s
draftees12225253draftees
drafters12338533drafters
drafts105012533dra__fts
dragees9359483dra_gees
draggers11357393draggers
dragnet91211433dragnet_
dragonets11134503dragonets
drainers92811253drainers
drakes114715863dra_ke_s
drapers105313353dra_pers
drapes95419653dra_pe_s
drats66628373dra___ts
draughts13284753draughts
drawbars1483103drawbars
drawees11378363dra_wees
drawers113610073dra_wers
drawlers12307313drawlers
dribbed13326753dribbe_d
dribblers14274453dribblers
dribbles13348393dribbles
dribblet13347543dribblet_
driblet103712243driblet_
droplets1136063droplets
drubbed13406983drubbe_d
drubber12357863drubbe_r
druggets11313913druggets
drumbeats1442323drumbeats
dubbers124011823d_ubbers
durables11237013durable_s
ebbets10376833__ebbets
fabbest1438033_fabbest
gabbers124612833_gabbers
gibbets12417723_gibbets
gobbets12327643_gobbets
grabbed13368643grabbe_d
grabber12389763grabbe_r
grabbiest1435323grabbiest
grabblers14345513grabblers
grabbles13339893grabbles
grabens10367003gra_bens
grubbers13316203grubbers
jabbers183610583_jabbers
labrets939363_labrets
nabbers113710463_nabbers
rabats83116223_ra_bats
rabbeted1334443_rabbeted
rabbies113416053_rabbies
rabbins112811343_rabbins
rabbis102613163_rabb_is
rabbit102914563_rabbit_
rabbity14266303_rabbity
rabblers123810853_rabblers
rabbles113517973_rabbles
rabies85226023_rabie_s
rachets124516833_rachets
rackets134916873_rackets
ramets83517393_ra_mets
ramjets1635163_ramjets
rebbes10313533_rebbe_s
ribbers113913183_ribbers
riblets93412553_riblets
robbers112814163_robbers
rubbers113913193_rubbers
sabbats1138633_sabbats
slabbers123610123slabbers
stabbers12268733stabbers
swabbers15316743swabbers
tablets94714383_tablets
yabbers14389353_yabbers

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.436409841.7
2DLD Change Limit1461621237.25320151.9
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.73523101.6
 
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.