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 “byroads” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

182 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
byroads133529(None) 
broads94515151b_roads
byroad1236621byroad_
brads85528292b_r_ads
breads95419202b_reads
broad84817692b_road_
broods95416382b_roods
bywords1634282bywords
inroads837042inroads
myriads1334352myriads
roads66523622__roads
abroad9310943abroad_
aroids75118223_aroids
bads77048863b___ads
ballads104212913ballads
barcas101016603barca_s
bards87139643bar__ds
barmaids1345943barmaids
barongs105310833barongs
barons85025383baro_ns
baywoods1745593baywoods
beads85429503b__eads
becrowds1683773becrowds
beglads11127263beglads
begroans1145503begroans
beheads1338523beheads
beholds1336423beholds
bemoans1138253bemoans
beyonds1335063beyonds
bezoars1836793bezoars
bipods11408593bipo_ds
birds85421333bir__ds
biros75325133biro__s
bloats85215763b_loats
blonds95213343b_londs
bloods94614843b_loods
boards94616933b__oards
boars75229603b__oars
boas66150833b__oa_s
boats75635153b__oats
bods76244713b__o_ds
bolds85825283b__olds
bonds86126843b__onds
borals86721913bor_als
boras75938303bor_a_s
boreas85421733borea_s
borons85520543boro_ns
boyhoods1744883boyhoods
brad75234343b_r_ad_
braes75735053b_r_aes
brags85625103b_r_ags
braids95015693b_raids
brands95118943b_rands
brans75437433b_r_ans
bras65746453b_r_a_s
brass75428023b_r_ass
brats75336013b_r_ats
braws106425193b_r_aws
brays106723113b_r_ays
bread85523113b_read_
bready124511183b_ready
breaks124816423b_reaks
breams104815043b_reams
breeds94914883b_reeds
briards10398553b_riards
briars84814823b_riars
broach133611113b_roach
broadax1744453b_roadax
broaden10289143b_roaden
broadens11267243b_roadens
broader103412613b_roader
broadest1138573b_roadest
broadish1446933b_roadish
broadly1337153b_roadly
brocade1238533b_rocade
brocades1358713b_rocades
brocks145214153b_rocks
brogans1049663b_rogans
broils84114173b_roils
bromals1139743b_romals
bromes104719763b_romes
bromids12278603b_romids
bromos104213313b_romos
broncs101611153b_roncs
brood84620243b_rood_
broody124510083b_roody
brooks125813883b_rooks
brooms104915873b_rooms
broos75126413b_ro_os
bros65635663b_ro__s
broses86524403b_roses
broths115013923b_roths
browns116415633b_rowns
brows105425983b_ro_ws
burans85019303bur_ans
buras74736303bur_a_s
burds84626063bur__ds
bureaus979293bureaus
burials93612083burials
burkas124513803burka_s
burlaps1156253burlaps
burqas174410903burqa_s
bursars94510893bursars
bursas85318273bursa_s
busloads1144153busloads
byelaws1533263byelaws
bygones1335913bygones
bylaws14415833by_laws
bypass1345043by_pass
byplays1743103byplays
byres104421383byr__es
byrled12437173byrled_
byrls105711233byr__ls
byrnies12378573byrnies
byways1734673by_ways
byword1535053byword_
byworks1944543byworks
carloads1138393carloads
croaks125812983_croaks
crowds124910763_crowds
cycads14476213cy_cads
dreads84115023_dreads
droids84712583_droids
dryads11436623_dryads
dyads10549973dy__ads
eyras84715923eyr_a_s
farads104713273far_ads
fronds106412343_fronds
goads77022853__goads
grads75625753_gr_ads
groans74815063_groans
groats74816653_groats
gyrons105511223gyro_ns
gyros95616483gyro__s
hydroids1647763hydroids
hyoids1377673hy_oids
inroad737933inroad_
loads65323373__loads
myriad1235913myriad_
ogdoads1042993ogdoads
onloads8246673onloads
oreads73915773_oreads
payloads1445293payloads
proas75028803_proa_s
prods85523553_pro_ds
pyrans11411063pyr_ans
pyrolas1239863pyrolas
pyrones123113303pyrones
pyropes142210193pyropes
pyros105718293pyro__s
pyrosis12411653pyrosis
rads56046603__r_ads
reads64835273__reads
reloads8911313reloads
rereads81512293rereads
road56332113__road_
roams74919613__roams
roans54926443__roans
roars55622243__roars
rods56442063__ro_ds
roods65125283__roods
sarods74918573saro_ds
scrods94111613scro_ds
shrouds1136023shrouds
spreads1039763spreads
strouds837803strouds
synods1077953syno_ds
threads11419953threads
throats104612193throats
thyroids1546003thyroids
toads65621073__toads
toroids8310653toroids
treads74817923_treads
triads74513533_triads
troaks104410603_troaks
tyros85118593tyro__s
unloads8278523unloads
uploads10266503uploads
uproars986453uproars
viroids1137923viroids
woads94818443__woads
yods86531183_y_o_ds

Search took 7 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 Filter1786911340270.436409841.7
2DLD Change Limit1340271826.29621287.6
3Display Results1821820.0632888.9
 (SQL Overall)1786911826.79526297.4
 
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.