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

137 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
barraters113804(None) 
barrater10310141barrater_
barrators1148391barrators
narraters946701narraters
arrayers11125852_arrayers
barrackers1843762barrackers
barrages11711082barrage_s
barrator1048402barrator_
barratry13114472barrat_ry
barretors1146242barretors
barriers104311882barr_iers
barristers1244722barristers
barters94223032ba_r_ters
garroters1055812garroters
narrater838722narrater_
narrates8312762narrate_s
narrators947862narrators
parroters1156762parroters
warranters1344532warranters
abaters95115203_a_baters
aborters1038573abor_ters
abraders1137343_abraders
aerates74627493_aerate_s
aerators8315613_aerators
arbiters1038853_arbiters
arrangers1045823_arrangers
arrases71214543_arrase_s
arrayer10136703_arrayer_
arresters948193_arresters
arrivers11137003_arrivers
backwaters2195163backwaters
baiters94619303ba__iters
ballasters1245093ballasters
balloters1157673balloters
balusters1136643balusters
bandagers1335883bandagers
banisters11189473banisters
banters94623113ba__nters
baratheas1444933ba_ratheas
barbate11314543barbate__
barbers114317503ba_r_bers
bardolaters1452703bardolaters
bargainers1343873bargainers
barites94322333ba_rite_s
barkers134318513ba_r_kers
barometers14198513barometers
barracker1744653barracker_
barracks1636883barra_cks
barrage10710843barrage__
barraged1297683barrage_d
barrancas1345093barrancas
barrancos1344203barrancos
barratries1245733barratries
barrels94514363barr__els
barrener1038333barrener_
barrens94414323barr__ens
barres84427543barr__e_s
barretor1046713barretor_
barretry13115183barret_ry
barrets94917103barr__ets
barrettes1149063barrettes
barrier94017733barr_ier_
barrister1145733barrister_
barter85525373ba_r_ter_
barterers11269633barterers
barwares13610093barware_s
barytes124611153ba_ryte_s
basters94930303ba__sters
bathwaters1843533bathwaters
batters94626013ba__tters
beaters94925043b__eaters
berates94126873b_erate_s
bereavers1446123bereavers
betrayers1445013betrayers
bewrayers1743483bewrayers
bleaters103412323b_leaters
bloaters103311023b_loaters
blurters10348373blur_ters
boaters93419243b__oaters
borates94823013b_orate_s
borrowers1474023borrowers
bracers114616703b__racers
bravers124715523b__ravers
brayers124511903b__rayers
brazers184513943b__razers
breakers143810973b_reakers
breathers14319103b_reathers
bruiters10329143b_ruiters
burrers93814493burr__ers
burrowers1483493burrowers
bursters1038983b_ursters
carates95630613ca_rate_s
carmakers1736923carmakers
carriers103614203carr_iers
carters95327253ca_r_ters
castraters1246473castraters
craters95021893__craters
darters84017603da_r_ters
farriers113610743farr_iers
ferrates113013423ferrate_s
ferreters1246253ferreters
fraters103517213__fraters
garotters1055033garotters
garroter956573garroter_
garrotes969363garrote_s
garters84218233ga_r_ters
graters85419743__graters
harriers113712433harr_iers
harrowers1555683harrowers
karates115617473ka_rate_s
kraters114212343__kraters
larrupers1142523larrupers
maceraters14226633maceraters
marketers1545983marketers
marrers93414313marr__ers
marriers103312473marr_iers
narrate7313493narrate__
narrated9310323narrate_d
narrator847563narrator_
paraders113113113pa_raders
parriers103612903parr_iers
parroter1058203parroter_
partakers1536563partakers
praters94921653__praters
raters63936583___raters
saturaters1045563saturaters
serrates82617023serrate_s
tarpapers1344273tarpapers
tarriers83411713tarr_iers
tartrates979563tartrate_s
treaters83615843_treaters
variates111214983variate_s
warmakers1845633warmakers
warrantees1343443warrantees
warranter1245203warranter_
warrantors1343043warrantors
warreners1236193warreners

Search took 10 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411378.61017263.8
3Display Results1371370.0462978.3
 (SQL Overall)1786911379.07919681.8
 
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.