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

322 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
trees5583576(None) 
brees75632551brees
drees65628521drees
frees86131391frees
grees65132471grees
prees75937171prees
rees45364191_rees
tees45353581t_ees
threes97117321threes
tree47745811tree_
treed65626731treed
treen55622751treen
treens65317871treens
treks96016851treks
tres46542901tr_es
tress55423161tress
trets55928021trets
trews86118891trews
treys85018211treys
tries55742811tries
trues54925321trues
tyees86019451tyees
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
dees56356632_dees
dree56638322dree_
dreed75222842dreed
dregs76114862dregs
dreks105714752dreks
dress65319832dress
dries64733672dries
entrees71813772entrees
epees75219832epees
ernes55224812ernes
erses55826802erses
etwees9348792etwees
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
reds56042862_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
steres63929532steres
streek104111412streek
streeks11378712streeks
streel64214022streel
streels73811342streels
street64125772street
streets73312612streets
streps86218062streps
stress66616672stress
strews96817102strews
tabes76033922tabes
taces76237802taces
taels56822072taels
tajes124920692tajes
takes94437792takes
tales55451372tales
tames75242012tames
tapes75838602tapes
tares57456562tares
targes74524602targes
tarres64723042tarres
tates55444982tates
taxes124730822taxes
teas45851492t_eas
teds54932572t_eds
tee38366872t_ee_
teed55439262t_eed
teel46335802t_eel
teels55726372teels
teem66132602t_eem
teems76019782teems
teen45938202t_een
teens56227482teens
tegs56031492t_egs
teles54536002teles
tels46841692t_els
tens45647412t_ens
tepees84215242tepees
terces83921412terces
terms75523472terms
ternes65422902ternes
terns55226872terns
terse55026822terse
tets45847462t_ets
tews76431642t_ews
thebes115914492thebes
thee78039062thee_
themes115319252themes
thens85921832thens
theres96525472theres
these86519012these
theses96517972theses
thews117416192thews
three87526912three_
threep115910112threep
threeps12687042threeps
throes97518672throes
tides64830152tides
tiers55526522tiers
ties45248312t_ies
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
tmeses85712242tmeses
toeas55726422toeas
toes46956442t_oes
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topees85519702topees
topes76941762topes
tores55352672tores
tories65435882tories
torses64727952torses
tortes64826052tortes
totes55139682totes
traces85329932traces
trades75724502trades
trams75327672trams
trans54933042trans
trapes85024462trapes
traps75727482traps
trass56226472trass
traves94222742traves
trays85623432trays
tread64821702tread
treads74817922treads
treat56240352treat
treats64821692treats
trebles9311442trebles
tref77030992tr_ef
trek86222312tr_ek
trend64817452trend
trends75513542trends
tresses73719542tresses
tressy9448552tressy
tret46653532tr_et
trevet94818912trevet
trevets10499972trevets
trey77228792tr_ey
tribes85119022tribes
trices84826332trices
tried65026912tried
trienes74118412trienes
triens65417542triens
trier54328532trier
triers64321522triers
trigs65423062trigs
trikes105419492trikes
trims75021472trims
trines64132562trines
trios55528092trios
tripes85324872tripes
trips74923362trips
trogs67022602trogs
trois57226092trois
trokes104019262trokes
trones65629282trones
tropes84824352tropes
trots56629942trots
troves94719112troves
trows88826182trows
troys86418612troys
truces84916332truces
true46725852true_
trued65117692trued
truer54916642truer
truest64816192truest
trugs65516802trugs
truss54916922truss
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tureen63312722tureen
tureens7289872tureens
turves94212692turves
tutees6514552tutees
tuxes124316042tuxes
twaes86513662twaes
twee76827082twee_
tweed94915092tweed
tweeds10498432tweeds
tween84413742tween
tweens9489842tweens
tweet84823982tweet
tweets94210102tweets
tyee75131422tyee_
tyers86220052tyers
tyes76433372t_yes
tykes125817062tykes
tynes85920302tynes
types105721062types
tyres84725232tyres
ureas55826012ureas
urges64619912urges
vees75439432_vees
wees76249122_wees
wrens85016242wrens
wries85827742wries
zees136331892_zees

Search took 3 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 Limit538003221.70331591.3
3Display Results3223220.0933462.4
 (SQL Overall)1786913222.09285416.3
 
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.