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

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

170 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
drabs8511967(None) 
crabs95421391crabs
dabs77139401d_abs
darbs85323261darbs
drab76226451drab_
drags75521111drags
drams86025831drams
drats66628371drats
draws95119371draws
drays95819771drays
dribs85115061dribs
drubs85913831drubs
grabs85719691grabs
abs59356072__abs
araks94820882araks
arbs66834732ar_bs
barbs95928192barbs
blabs95619632blabs
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336022brats
braws106425192braws
brays106723112brays
cabs86739422_cabs
carbs96031462carbs
crab85727672crab_
crags85622572crags
crams96229152crams
craps95328642craps
crass76328042crass
craws105723122craws
cribs94516752cribs
dab67455562d_ab_
dads67442782d_ads
dags66642602d_ags
dahs88231812d_ahs
dais57040702d_ais
daks97130602d_aks
dals57145122d_als
dams77444372d_ams
dans56748152d_ans
daps77239162d_aps
darb76033532darb_
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
daubs85014562daubs
daws86638242d_aws
days87637132d_ays
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
debs76530242d_ebs
derats74625062derats
derays105514252derays
dhaks13479702dhaks
dhals95415442dhals
dials64925342dials
dibs76233692d_ibs
dirams94413702dirams
doats65224882doats
drably123511612drably
draff125615662draff
draffs13617902draffs
draft95526682draft
drafts105012532drafts
drag64825052dra_g
drail65020972drail
drails74716952drails
drain65222892drain
drains73719402drains
drake104918302drake
drakes114715862drakes
dram75832002dra_m
drama85117432drama
dramas95814672dramas
drank104816202drank
drape85319632drape
drapes95419652drapes
drat56247832dra_t
drave95219272drave
draw85623012dra_w
drawl95516012drawl
drawls105511392drawls
drawn95614242drawn
dray85428092dra_y
dreads84115022dreads
dreams94513982dreams
drears74614252drears
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dress65319832dress
drib76823262drib_
dries64733672dries
drips85417232drips
drops85719502drops
dross65418092dross
drub75920132drub_
drugs75214652drugs
drums85415872drums
dryads11436622dryads
drys86314802dr_ys
duads76515342duads
duals65620082duals
dubs78432192d_ubs
dumbs105915752dumbs
duras65727732dura_s
dyads10549972dyads
eras45441502era_s
fabs98635862_fabs
flabs105818642flabs
frags96322172frags
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
gabs76740422_gabs
garbs86321412garbs
grab75427612grab_
grads75625752grads
grams85327312grams
grans64832542grans
grass66125202grass
grays95621332grays
grubs86312602grubs
jabs135830092_jabs
kabs107130852_kabs
labs67145122_labs
nabs66236192_nabs
orals55826482orals
orbs66626252or_bs
prams96125512prams
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
rads56046612_rads
rags55448372_rags
rais45252622_rais
rams65950772_rams
raps66247732_raps
ras37575392_ra_s
rats46260372_rats
raws75238212_raws
rays77642352_rays
rebs65733562_rebs
ribs65833032_ribs
robs65837872_robs
rubs66133492_rubs
sabs66643742_sabs
scabs94818642scabs
slabs75322642slabs
stabs76221382stabs
swabs105817272swabs
tabs66842982_tabs
trams75327672trams
trans54933042trans
traps75727482traps
trass56226472trass
trays85623432trays
urbs65922062ur_bs
wabs97337232_wabs
wraps105617152wraps

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001701.54634799.5
3Display Results1701700.0335151.5
 (SQL Overall)1786911701.87595301.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.