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

192 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
barrater1031014(None) 
barraters1138041barraters
barrator1048401barrator
narrater838721narrater
arrayer10136702_arrayer
barbate11314542barbate_
barracker1744652barracker
barrage10710842barrage_
barraged1297682barraged
barrages11711082barrages
barrators1148392barrators
barratry13114472barratry
barrener1038332barrener
barretor1046712barretor
barrier94017732barr_ier
barrister1145732barrister
barter85525372ba_r_ter
garroter956572garroter
narrate7313492narrate_
narrated9310322narrated
narraters946702narraters
narrates8312762narrates
narrator847562narrator
parroter1058202parroter
warranter1245202warranter
abater85518123_a_bater
aberrated1245873aberrated
aborter939933abor_ter
abrader1038643_abrader
abrupter1243793abrupter
aerate64830553_aerate_
aerated85322373_aerated
aerates74627493_aerates
aerator7314843_aerator
arbiter939933_arbiter
arranger936883_arranger
arrased8149863_arrased
arrases71214543_arrases
arrayed11117153_arrayed
arrayers11125853_arrayers
arrester839253_arrester
arriver10117793_arriver
aurate64426473_aurate_
aurated83817793_aurated
baccate131011263baccate_
baccated15148373baccated
backwater2096753backwater
baiter84422553ba__iter
ballaster1145973ballaster
balloter1078893balloter
baluster1037053baluster
bandager1237703bandager
banister10199973banister
banter84825333ba__nter
barathea1345283ba_rathea
barber104419323ba_r_ber
bardolater1343843bardolater
barer74535803ba_r__er
bargainer1244563bargainer
barite84224813ba_rite_
barites94322333ba_rites
barker124822863ba_r_ker
barkier133814483ba_rkier
barmier114313043ba_rmier
barnier93213673ba_rnier
barometer13189043barometer
barrable1249243barrable
barrack1538253barra_ck
barracked1844753barracked
barrackers1843763barrackers
barracks1636883barracks
barranca1245583barranca
barranco1244943barranco
barratries1245733barratries
barre75929543barr__e_
barred95725793barr__ed
barrel84517873barr__el
barreled1137843barreled
barren85317613barr__en
barres84427543barr__es
barret84930483barr__et
barretors1146243barretors
barretry13115183barretry
barrets94917103barret_s
barrette1039783barrette
barrettes1149063barrettes
barriers104311883barr_iers
barristers1244723barristers
barterer102711633barterer
barters94223033ba_r_ters
barware12610703barware_
barwares13610093barwares
baryte115312883ba_ryte_
barytes124611153ba_rytes
baster85333593ba__ster
bathwater1744363bathwater
batter84928873ba__tter
beater84729393b__eater
berate84729023b_erate_
berated104422133b_erated
berates94126873b_erates
bereaver1346673bereaver
betrayer1345643betrayer
bewrayer1643733bewrayer
bleater94515303b_leater
bloater94013423b_loater
blurter9419833blur_ter
boater84622093b__oater
borate85026153b_orate_
borated104116363b_orated
borates94823013b_orates
borrower1384833borrower
bracer104620583b__racer
braver114719043b__raver
brawer114216333b__rawer
brayer115315313b__rayer
brazer174917533b__razer
breaker133912923b_reaker
breather133610593b_reather
broader103412613b_roader
bruiter93710633b_ruiter
burrer83718473burr__er
burrier93613553burr_ier
burrower1374263burrower
bursate94111203bursate_
burster9310293b_urster
carate84734003ca_rate_
carates95630613ca_rates
carmaker1637313carmaker
carrier93619583carr_ier
carrotier1146623carrotier
carter84932273ca_r_ter
castrater1148523castrater
cirrate92413493cirrate_
crater85026643__crater
darter75320363da_r_ter
farrier103514893farr_ier
ferrate103014043ferrate_
ferrates113013423ferrates
ferreter1136543ferreter
forrader1236153forrader
frater94520593__frater
garotter965943garotter
garreted1057523garreted
garrote8510103garrote_
garroted1056783garroted
garroters1055813garroters
garrotes969363garrotes
garter74420513ga_r_ter
grater74625443__grater
greater84416493_greater
harrier104417753harr_ier
harrower1446363harrower
irater65218353__irater
karate105320923ka_rate_
karates115617473ka_rates
krater104014313__krater
lariated91212063lariated
larruper1042743larruper
macerater13259523macerater
marketer1437383marketer
marrer83716673marr__er
marrier93817523marr_ier
narrators947863narrators
narrower1145063narrower
parader103914863pa_rader
parrier93717653parr_ier
parroted1158843parroted
parroters1156763parroters
partaker1436873partaker
prater84825353__prater
rater54943283___rater
saturater947903saturater
serrate73017543serrate_
serrated92513433serrated
serrates82617023serrates
tarpaper1244603tarpaper
tarrier74323173tarr_ier
tarter64023563ta_r_ter
tartrate899683tartrate_
tartrated1096643tartrated
tartrates979563tartrates
treater74219833_treater
variate101316433variate_
variated121211393variated
variates111214983variates
warmaker1735973warmaker
warranted1345013warranted
warrantee1245273warrantee
warranters1344533warranters
warrantor1243213warrantor
warrener1136913warrener

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621927.54619369.5
3Display Results1921920.0932064.5
 (SQL Overall)1786911928.04522211.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.