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

302 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
tree4774581(None) 
bree67241261bree
dree56638321dree
free75940181free
gree56641561gree
pree67044731pree
ree37974071_ree
tee38366871t_ee
thee78039061thee
three87526911three
treed65626731treed
treen55622751treen
trees55835761trees
tref77030991tref
trek86222311trek
tres46542901tres
tret46653531tret
trey77228791trey
true46725851true
twee76827081twee
tyee75131421tyee
agee56241492agee
agree65226032agree
ajee115928232ajee
akee85936812akee
alee46652322alee
are37874572ar_e
area45843392area
areae55229742areae
arene55329412arene
ares45871022ares
arete56031352arete
arse46539272arse
awee76336642awee
bee56262402_bee
brae65639112brae
bred75130972bred
brede85520502brede
breed85526692breed
brees75632552brees
bren65629562bren
breve105317052breve
brew95023562brew
brie65837902brie
cee55952702_cee
cere66741472cere
cred76530882cred
creed85727392creed
creek114917392creek
creel75121482creel
creep95218102creep
creme94319322creme
crepe95520722crepe
crew96122682crew
dee47665822_dee
dere56845902dere
dreed75222842dreed
drees65628522drees
dreg66821652dreg
drek96321092drek
drew86221672drew
entree61817882entree
epee64628502epee
ere36352772er_e
erne46727432erne
etwee84115332etwee
fee66862012_fee
fere76342232fere
flee76238792flee
frae75330472frae
freed95223542freed
freer86021242freer
frees86131392frees
frere85617722frere
fret75845042fret
froe75329992froe
gee45359202_gee
ghee85726112ghee
glee55239062glee
grebe85114942grebe
greed75125692greed
greek105915942greek
green65522142green
grees65132472grees
greet65835322greet
grew85620262grew
grey85624042grey
grue55825712grue
here76447102here
hiree85427802hiree
ire36943172ir_e
ired55131872ired
ires45639282ires
jee106648642_jee
knee85323602knee
kreep114610412kreep
krewe1238192krewe
laree56036292laree
lee36068142_lee
mere67244442mere
nee36657782_nee
ogee57629882ogee
ore36661832or_e
ores46056682ores
orle45630462orle
pee56066512_pee
pere66450262pere
preed85128122preed
preen75925052preen
prees75937172prees
prep86427672prep
prese75228382prese
prex135722972prex
prey96228482prey
prez156126312prez
puree74632842puree
re26153742_r_e
reb55844962_reb
rec55645462_rec
red46755802_red
rede55037672_rede
reed55549622_reed
reef74938212_reef
reek85232522_reek
reel45240532_reel
rees45364192_rees
ref66053292_ref
reg46146492_reg
rei35647252_rei
rem56150042_rem
rep55847802_rep
res35565042_res
ret35982832_ret
rete44944132_rete
rev65336622_rev
rex105740992_rex
roe36861082_roe
rue35549262_rue
rye66032542_rye
saree55044662saree
scree720031712scree
see35772262_see
sere46153472sere
siree55238812siree
skee85431472skee
spree74830862spree
stere55328542stere
streek104111412streek
streel64214022streel
street64125772street
strep77120852strep
strew89220662strew
tace65342512tace
tae38267052t_ae
tael46030712tael
take84739262take
tale46154162tale
tame66343662tame
tape64538142tape
tare45957622tare
tared69340052tared
tares57456562tares
targe65227092targe
tarre55825632tarre
tate44748602tate
tea37353322t_ea
ted46446562t_ed
teed55439262teed
teel46335802teel
teem66132602teem
teen45938202teen
tees45353582tees
teg45741622t_eg
tel35647902t_el
tele45040872tele
ten35856112t_en
tepee74724212tepee
terce75721842terce
terete6319332terete
term66233152term
tern46134802tern
terne56426152terne
terse55026822terse
tet39274992t_et
tew66640152t_ew
thae76825562thae
the67436052t_he
thebe107515432thebe
them97427042them
theme105921732theme
then78429692then
there87527392there
these86519012these
thew108226232thew
they107223752they
threep115910112threep
threes97117322threes
threw1117315712threw
throe89321422throe
tide55237382tide
tie36557532t_ie
tied55535212tied
tier44936142tier
ties45248312ties
tike85534482tike
tile45451442tile
time66235012time
tine45855132tine
tire46143352tire
tired65228902tired
tires55437492tires
toe310166852t_oe
toea46732332toea
toed56137042toed
toes46956442toes
toke86738492toke
tole46052902tole
tome67543192tome
tone46953742tone
tope65946382tope
topee76029952topee
tore47359322tore
tores55352672tores
torse55833332torse
torte55431702torte
tote46643672tote
trace75829612trace
trad55630912trad
trade65026042trade
tram67034552tram
trap67532802trap
trave85223032trave
tray77632592tray
tread64821702tread
treat56240352treat
treble8311662treble
treens65317872treens
treks96016852treks
trend64817452trend
tress55423162tress
trets55928022trets
trevet94818912trevet
trews86118892trews
treys85018212treys
tribe74420272tribe
trice75127492trice
tried65026912tried
triene64316382triene
trier54328532trier
tries55742812tries
trig55528162trig
trike95320162trike
trim65329522trim
trine54734602trine
trio45233342trio
trip66830392trip
tripe75425382tripe
trite54730032trite
trod57627952trod
trode65322852trode
trog57628212trog
troke94821052troke
trone55131862trone
trop66833302trop
trope75725802trope
trot46351312trot
trove85221922trove
trow78031422trow
troy77429682troy
truce75118692truce
trued65117692trued
truer54916642truer
trues54925322trues
trug55720042trug
try66529672tr_y
tube65828662tube
tule45735872tule
tune45635862tune
tureen63312722tureen
tutee5423522tutee
twae74719572twae
tweed94915092tweed
tween84413742tween
tweet84823982tweet
tye65837442t_ye
tyees86019452tyees
tyer75323392tyer
tyes76433372tyes
tyke115720502tyke
tyne76325052tyne
type96223742type
tyre75428252tyre
tyred95816432tyred
tyres84725232tyres
urea46528062urea
urge54722422urge
vee65750182_vee
wee66760812_wee
were76238332were
whee105429592whee
wren78221682wren
zee126143232_zee

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.280638182.1
2DLD Change Limit298723020.78038297.4
3Display Results3023020.0634793.7
 (SQL Overall)1786913021.123159119.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.