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

211 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
breed8552669(None) 
bleed85019801bleed
bread85523111bread
bred75130971br_ed
brede85520501brede
bree67241261bree_
breeds94914881breeds
brees75632551brees
brewed125411871brewed
creed85727391creed
dreed75222841dreed
freed95223541freed
greed75125691greed
preed85128111preed
reed55549621_reed
treed65626731treed
agreed84712502agreed
arced88224162arced
armed86324432armed
baaed85218162baaed
baked126130772baked
baled85436442baled
baned85436352baned
barbed115121312barbed
barded105426422barded
bared85144482bared
barfed125416382barfed
barged105822642barged
barked135027312barked
barned95623582barned
barred95725792barred
based85331582based
bated85935532bated
bayed115423022bayed
bead75937922b_ead
bed67950622b__ed
bee56262402b_ee_
beedi8711662b_eedi
beef96233672b_eef
beefed123510872beefed
been65335782b_een
beep85931212b_eep
beeped115313452beeped
beer65635992b_eer
bees65453382b_ees
beet66457542b_eet
bend76435262b_end
beret74946362beret
bermed115217722bermed
bided95424962bided
bield84614652bield
biked125320032biked
biped104718832biped
birded104414302birded
birled94416992birled
birred94713202birred
bled75729312b_led
bleeds95211592bleeds
bleep95013452bleep
blend85317452blend
blued84520322blued
boded95124962boded
boned85133242boned
booed85127272booed
bored85034302bored
boreen8314312boreen
borked135117292borked
bowed114533422bowed
boxed154318612boxed
braced115420602braced
brad75234342br_ad
brae65639112brae_
braes75735052braes
braid85822262braid
braked135318692braked
brand85124492brand
braved124817442braved
brayed124615782brayed
brazed184717082brazed
breaded115014062breaded
breads95419202breads
bready124511182bready
break115319402break
bream95121812bream
breamed124011592breamed
bredes94818472bredes
breech13348262breech
breeder103210042breeder
breeks125310792breeks
breeze17298962breeze
breezed19287052breezed
breezy20295852breezy
bren65629562br_en
brens75823362brens
brent75734132brent
breve105317052breve
breves115516422breves
brevet115717332brevet
brew95023562br_ew
brewer114812542brewer
brews105617072brews
bribed115312842bribed
bride86425532bride
brie65837902brie_
brief105422592brief
briefed1335742briefed
brier74527402brier
bries74942152bries
brined95118412brined
broad84817692broad
brood84620242brood
browed125216392browed
bruted95113262bruted
bruxed16466982bruxed
buried94822372buried
burked135220882burked
burled94825382burled
burned95818962burned
burped116215502burped
burred95820722burred
burseed1049502burseed
burweed1347822burweed
bused85624492bused
byrled12437172byrled
cered85227442cered
cred76530882cr_ed
creeds94714772creeds
creek114917392creek
creel75121482creel
creep95218102creep
creped114115702creped
crewed125316552crewed
cried84624282cried
deed65340902_deed
dread74419022dread
dree56638322dree_
drees65628522drees
dried75321382dried
erred65915672erred
feed84538902_feed
free75940182free_
freer86021242freer
frees86131392frees
fremd115010322fremd
fried95322912fried
geed65435502_geed
gleed75320572gleed
gree56641562gree_
greeds84314282greeds
greedy11518842greedy
greek105915942greek
green65522142green
grees65132472grees
greet65835322greet
greyed114610602greyed
heed86437602_heed
inbreed10267642inbreed
ired55131872ir_ed
irked104510922irked
jeed125428502_jeed
jereed144012062jereed
kneed104612052kneed
kreep114610412kreep
meed74934702_meed
need54934152_need
orbed85516192orbed
oread64619602oread
peed76239182_peed
pree67044732pree_
preen75925052preen
prees75937172prees
premed114617752premed
preyed125313192preyed
pried84426862pried
pureed95017802pureed
read55942532_read
rebreed104611072rebreed
red46755802_r_ed
redd66323172_redd
rede55037662_rede
reded74829112_reded
ree37974072_ree_
reeds65430902_reeds
reedy910020282_reedy
reef74938212_reef
reek85232522_reek
reel45240532_reel
rees45364192_rees
refed93921922_refed
rend56136572_rend
rewed95425452_rewed
rued55729792_rued
screed95718922screed
seed55549482_seed
sered65737292sered
skeed105018982skeed
speed85526622speed
steed66024942steed
teed55439262_teed
tread64821702tread
tree47745812tree_
treen55622752treen
trees55835762trees
trend64817452trend
tried65026912tried
trued65117692trued
tweed94915092tweed
urged75316032urged
urped84615282urped
weed85637512_weed
wried95518562wried

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.0931921408.6
2DLD Change Limit538002111.67332157.8
3Display Results2112110.0464587.0
 (SQL Overall)1786912111.81298615.3
 
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.