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

208 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
drys8631480(None) 
days87637131days
deys85027471deys
drays95819771drays
dry76526031dry_
abys97221882abys
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137492arms
ars37670932ar_s
arts49650262arts
aryl75922342aryl
aryls87015812aryls
ays67050292_ays
bays97143912bays
beys913829552beys
boys96737332boys
bras65746452bras
brays106723112brays
bris65539612bris
bros65635662bros
buys95726792buys
bys85229462_bys
cays95437672cays
coys97537242coys
cris66233432cris
crus65828482crus
cry89726242cry_
dabs77139402dabs
dads67442772dads
dags66642602dags
dahs88231812dahs
dais57040702dais
daks97130602daks
dals57145122dals
dams77444372dams
dans56748152dans
daps77239162daps
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
daws86638242daws
day76254112day_
debs76530242debs
dees56356632dees
dels56745472dels
dens55945072dens
derays105514252derays
derms85022892derms
devs86424032devs
dews86230602dews
dey77243372dey_
dibs76233682dibs
dies55653522dies
difs86027322difs
digs66036052digs
dims75435022dims
dins56652042dins
dips75536912dips
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
dis46459892d_is
diss56434482diss
dits56450522dits
docs75631152docs
does56554472does
dogs66440152dogs
dols56943052dols
doms76239572doms
dons56048702dons
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dors
dory85836232dory_
dos48062312d_os
doss56235042doss
dots55647662dots
dows85941052dows
drab76226452drab
drabs85119672drabs
drag64825052drag
drags75521112drags
dram75832002dram
drams86025832drams
drat56247832drat
drats66628372drats
draw85623012draw
draws95119372draws
dray85428092dray
dree56638322dree
drees65628522drees
dreg66821652dreg
dregs76114862dregs
drek96321092drek
dreks105714752dreks
dress65319832dress
drest65530342drest
drew86221672drew
drib76823262drib
dribs85115062dribs
dries64733672dries
drip76223952drip
drips85417232drips
drop75324402drop
drops85719502drops
dross65418092dross
drub75920132drub
drubs85913832drubs
drug65718132drug
drugs75214652drugs
drum76521592drum
drums85415872drums
druse64817662druse
dryad10477582dryad
dryads11436622dryads
dryer95111462dryer
dryers10449272dryers
dryest104811122dryest
dryish1336322dryish
dryly12538452dryly
dubs78432192dubs
duds65530142duds
dues56045502dues
dugs614832282dugs
duns55140432duns
duos56728132duos
dups75929512dups
duras65727732duras
dures65635922dures
durns64819872durns
duros65422692duros
durrs65519992durrs
dye75334842d_ye
dyes85331892dyes
eras45441502eras
ergs55523812ergs
erns45428232erns
eros45238452eros
errs45622532errs
ers36046282er_s
fays108535362fays
foys105628292foys
frays116920102frays
fry96226502fry_
gays87338022gays
goys86328412goys
grays95621332grays
greys96614852greys
guys85019642guys
hays106138072hays
hoys107733932hoys
ires45639282ires
iris45732552iris
irks86220132irks
jays146328342jays
joys146624662joys
kays116032192kays
keys116322162keys
kris86423602kris
lays76043252lays
leys76430182leys
mays96940032mays
nays75931592nays
orbs66626252orbs
orcs67025432orcs
ores46056682ores
ors35750112or_s
orts46538332orts
oryx14510212oryx
pays95940222pays
prays105022432prays
preys105717782preys
pros65742782pros
pry85728052pry_
ras37575392_ras
rays77642352rays
res35565042_res
rya67622012_rya
ryas77224612_ryas
rye66032542_rye
ryes75529352_ryes
says75942102says
soys75233932soys
sris45434152sris
toys78036342toys
trays85623432trays
tres46542902tres
treys85018212treys
troys86418612troys
try66529672try_
tryst84716222tryst
urbs65922062urbs
urds55922432urds
urns46323902urns
urps66920482urps
urus46426142urus
ways107737952ways
whys137011662whys
wry96524702wry_
yays105728912yays

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 Filter178691298720.266671770.7
2DLD Change Limit298722080.86034734.9
3Display Results2082080.0464521.7
 (SQL Overall)1786912081.172152466.7
 
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.