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

284 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
bree6724126(None) 
bee56262401b_ee
brae65639111brae
bred75130971bred
brede85520501brede
breed85526691breed
brees75632551brees
bren65629561bren
breve105317051breve
brew95023561brew
brie65837901brie
dree56638321dree
free75940181free
gree56641561gree
pree67044731pree
ree37974071_ree
tree47745811tree
agee56241492agee
agree65226032agree
ajee115928232ajee
akee85936812akee
alee46652322alee
are37874572ar_e
area45843392area
areae55229742areae
arene55329412arene
ares45871022ares
arete56031352arete
arse46539272arse
awee76336642awee
babe86835812babe
bade75140882bade
bake105637512bake
bale66353842bale
bane65250422bane
barbe95328282barbe
barde85330772barde
bare65460522bare
bared85144482bared
barege94713542barege
barer74535802barer
bares75457132bares
barge85631022barge
bargee94624442bargee
barre75929542barre
barye105021492barye
base64847022base
bate66552422bate
be47948942b__e
bed67950622b_ed
beef96233672beef
been65335782been
beep85931212beep
beer65635992beer
bees65453382bees
beet66457542beet
beg65944132b_eg
bel57148462b_el
ben56554922b_en
bene66439492bene
beret74946362beret
berg75425542berg
berk105929842berk
berm86732752berm
berme96022942berme
bes56557432b_es
bet58376672b_et
bey86645422b_ey
bice86235552bice
bide76041472bide
bier65531822bier
bike106532592bike
bile66147172bile
bine66650852bine
bireme10310142bireme
birle75023632birle
birse74517402birse
bise66437092bise
bite66546992bite
bize155926282bize
blae66134642blae
bleb85425222bleb
bled75729312bled
bleed85019802bleed
bleep95013452bleep
blet66247672blet
blew94722432blew
blue65328462blue
bode75838752bode
bole66448692bole
bone65949322bone
bore66051332bore
bored85034302bored
boreen8314312boreen
borer75131272borer
bores76448252bores
borne77926792borne
bra56339462br_a
brace95629272brace
brad75234342brad
braes75735052braes
brag75229722brag
brake116025342brake
bran65740382bran
bras65746452bras
brat66055542brat
brave104925502brave
braw94829562braw
bray95232902bray
braze165423452braze
bread85523112bread
break115319402break
bream95121812bream
bredes94818472bredes
breech13348262breech
breeds94914882breeds
breeks125310792breeks
breeze17298962breeze
breezy20295852breezy
brens75823362brens
brent75734132brent
breves115516422breves
brevet115717332brevet
brewed125411872brewed
brewer114812542brewer
brews105617072brews
bribe94820772bribe
bribee104316362bribee
bride86425532bride
brief105422592brief
brier74527402brier
bries74942152bries
brig76528032brig
brim85629372brim
brin67038192brin
brine75132272brine
brio65432492brio
bris65539612bris
brit66350152brit
bro56236602br_o
broke116019782broke
brome94421972brome
broo65129822broo
bros65635662bros
brose75227032brose
brow97228442brow
brr56921922br_r
brrr65312292brrr
brume95817982brume
brut66537962brut
brute75321782brute
brux136315272brux
buret77444012buret
burgee97120592burgee
burke115122762burke
burse75527252burse
bute66739672bute
bye86134592b_ye
byes95230532byes
byre95023852byre
byres104421382byres
byte96521812byte
cee55952702_cee
cere66741472cere
cred76530882cred
creed85727392creed
creek114917392creek
creel75121482creel
creep95218102creep
creme94319322creme
crepe95520722crepe
crew96122672crew
dee47665822_dee
dere56845902dere
dreed75222842dreed
drees65628522drees
dreg66821652dreg
drek96321082drek
drew86221672drew
epee64628502epee
ere36352772er_e
erne46727422erne
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
preed85128112preed
preen75925052preen
prees75937172prees
prep86427672prep
prese75228382prese
prex135722972prex
prey96228482prey
prez156126312prez
puree74632842puree
re26153742_r_e
reb55844962_reb
rec55645462_rec
red46755802_red
rede55037662_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
roe36861072_roe
rue35549262_rue
rye66032542_rye
saree55044662saree
scree720031702scree
see35772262_see
sere46153472sere
siree55238812siree
skee85431472skee
spree74830862spree
tee38366872_tee
thee78039062thee
three87526912three
treed65626732treed
treen55622752treen
trees55835762trees
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
trey77228792trey
true46725852true
twee76827082twee
tyee75131422tyee
urea46528052urea
urge54722412urge
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.0802233637.5
2DLD Change Limit298722840.89033564.0
3Display Results2842840.0634507.9
 (SQL Overall)1786912841.033172982.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.