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

282 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
drees6562852(None) 
brees75632551brees
dees56356631d_ees
dree56638321dree_
dreed75222841dreed
dregs76114861dregs
dreks105714751dreks
dress65319831dress
dries64733671dries
frees86131391frees
grees65132471grees
prees75937171prees
rees45364191_rees
trees55835761trees
agrees74915322agrees
akees96119242akees
areas55935772areas
arenes64928392arenes
ares45871022ar_es
aretes64425352aretes
arles56735742arles
arses55733872arses
bees65453382_bees
braes75735052braes
bredes94818472bredes
bree67241262bree_
breed85526692breed
breeds94914882breeds
breeks125310792breeks
brens75823362brens
breves115516422breves
brews105617072brews
bries74942152bries
cees65941592_cees
ceres75540012ceres
creds85418772creds
creed85727392creed
creeds94714772creeds
creek114917392creek
creeks124812922creeks
creel75121482creel
creels84416942creels
creep95218102creep
creeps104213622creeps
creese84014332creese
creesh11328332creesh
cremes104517992cremes
crepes105419342crepes
cress75022832cress
crews105917502crews
cries75438402cries
daces85030682daces
dales66439742dales
dames85435852dames
darers75921872darers
dares66146702dares
dates65639152dates
dazes155024142dazes
debs76530242d_ebs
decrees102513122decrees
dee47665822d_ee_
deed65340902d_eed
deeds75423762deeds
deem75432892d_eem
deems85421772deems
deep76031882d_eep
deeps84921772deeps
deer56739022d_eer
deers64930522deers
deet57356582d_eet
deets65330242deets
degrees92810722degrees
dekes105224452dekes
deles65139252deles
dels56745472d_els
demes86032692demes
denes65639722denes
dens55945072d_ens
dere56845902dere_
derms85022892derms
devs86424032d_evs
dews86230602d_ews
dexes135224512dexes
deys85027472d_eys
dices86434242dices
dienes75719902dienes
dies55653532d_ies
dieses75218692dieses
diets66026642diets
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dirges84915102dirges
dites66339152dites
dives95832402dives
doers65225712doers
does56554472d_oes
doges75630162doges
doles67843752doles
domes85735562domes
donees74519492donees
dopes84935042dopes
dories75232362dories
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
drabs85119672drabs
dragees9359482dragees
drags75521112drags
drakes114715862drakes
drams86025832drams
drapes95419652drapes
drats66628372drats
drawees11378362drawees
draws95119372draws
drays95819772drays
dread74419022dread
dreads84115022dreads
dream85120392dream
dreams94513982dreams
drear65016902drear
drears74614252drears
dreck124812802dreck
drecks13459202drecks
dredges10379352dredges
dreg66821652dr_eg
drek96321092dr_ek
dresses83716172dresses
dressy10518142dressy
drest65530342drest
drew86221672dr_ew
dribs85115062dribs
dried75321382dried
drier64423962drier
driers74516732driers
driest74722752driest
drips85417232drips
drives105117112drives
drones75023432drones
drops85719502drops
dross65418092dross
droves105116672droves
drubs85913832drubs
drugs75214652drugs
drums85415872drums
drupes94912652drupes
druse64817662druse
druses75517252druses
dryer95111462dryer
dryers10449272dryers
dryest104811122dryest
drys86314802dr_ys
duces86327472duces
dudes75424372dudes
duels65619232duels
dues56045502d_ues
duets65323882duets
dukes105023472dukes
dunes65332172dunes
dupes86425932dupes
dures65635922dures
duress74712062duress
dweeb1137742dweeb
dweebs1233652dweebs
dyers96617132dyers
dyes85331892d_yes
dykes135215572dykes
dynes95917582dynes
epees75219832epees
ernes55224812ernes
erses55826802erses
fees76450602_fees
feres86038182feres
flees85828752flees
free75940182free_
freed95223542freed
freer86021242freer
freers94717302freers
freest95318282freest
freres94716172freres
frets85523402frets
fries85535602fries
froes86126692froes
gees55647882_gees
ghees95215552ghees
glees65027592glees
grebes93813612grebes
gree56641562gree_
greed75125692greed
greeds84314282greeds
greek105915942greek
green65522142green
greens75716872greens
greet65835322greet
greets75117422greets
greys96614852greys
grues65721962grues
heres86245902heres
hirees95117292hirees
ires45639282ir_es
jees115938542_jees
knees95114872knees
kreep114610412kreep
kreeps12427412kreeps
krewes1337922krewes
larees65323112larees
lees45455882_lees
meres75143572meres
ogees65119142ogees
ores46056682or_es
orles55326212orles
pees65257372_pees
peres76246642peres
pree67044732pree_
preed85128122preed
preen75925052preen
preens85020112preens
preps96220692preps
prese75228382prese
press75425952press
prexes154915952prexes
preys105717782preys
prezes173614692prezes
pries74339532pries
purees84721682purees
rebs65733562_rebs
recs65734182_recs
redes65139132_redes
reds56042872_reds
ree37974072_ree_
reed55549622_reed
reeds65430902_reeds
reef74938212_reef
reefs85121662_reefs
reek85232522_reek
reeks94124032_reeks
reel45240532_reel
reels55333262_reels
reest54938092_reest
refs75732242_refs
reges65628792_reges
regs55436572_regs
reis45343232_reis
rems66237722_rems
reps65937952_reps
res35565042_r_es
rets45352562_rets
revs75027052_revs
rexes124526952_rexes
roes45954142_roes
rues46044482_rues
ryes75529352_ryes
sarees65329942sarees
screes85023972screes
sees45361052_sees
seres55448892seres
sirees64624582sirees
skees95023122skees
sprees85620642sprees
tees45353582_tees
threes97117322threes
tree47745812tree_
treed65626732treed
treen55622752treen
treens65317872treens
treks96016852treks
tres46542902tr_es
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
tries55742812tries
trues54925322trues
tyees86019452tyees
ureas55826012ureas
urges64619912urges
vees75439432_vees
wees76249122_wees
wrens85016242wrens
wries85827742wries
zees136331892_zees

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 Limit538002821.59633709.3
3Display Results2822820.0763710.5
 (SQL Overall)1786912821.96890798.3
 
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.