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

116 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
barracks163688(None) 
arracks1387731_arracks
barrack1538251barrack_
carracks1637711carracks
arrack121110252_arrack_
barracked1844752barracked
barracker1744652barracker
barrackers1843762barrackers
barrages11711082barrages
barrancas1345092barrancas
barrancos1344202barrancos
caracks152211562ca_racks
carjacks2345572carjacks
carrack1548752carrack_
hatracks1737532hatracks
hayracks2045312hayracks
abreacts1245633abreacts
amtracks1696633amtracks
araks94820883_a_ra_ks
arras55626133_arra__s
arrases71214543_arrases
arrays95311683_arra_ys
attacks13126943_attacks
backpacks2044993backpacks
backs135729623b___acks
backtracks1943543backtracks
baldricks18162883baldricks
bannocks1644353bannocks
barbascos1542733barbascos
barcas101016603ba_r_cas
bareback1846093bareback_
baresarks1543433baresarks
bargains1178643bargains
barks115735813ba_r__ks
barmaids1345943barmaids
barnacle1245943barnacle
barnacles1355333barnacles
barrable1249243barrable
barracking1944713barracking
barracoon1343303barracoon
barracoons1442983barracoons
barracuda1452353barracuda
barracudas1552483barracudas
barrage10710843barra_ge
barraged1297683barraged
barranca1245583barranca
barranco1244943barranco
barrater10310143barrater
barraters1138043barraters
barrator1048403barrator
barrators1148393barrators
barratry13114473barratry
barrels94514363barr_els
barrens94414323barr_ens
barres84427543barr__es
barrets94917103barr_ets
barriers104311883barriers
barrios9310773barr_ios
barrooms1237893barrooms
barrows123411683barr_ows
barwares13610093barwares
bawcocks21113443bawcocks
bedrocks1745333bedrocks
bipacks1745043b_ipacks
blacks144914953b__lacks
bookracks1643603bookracks
boraces113716853b_oraces
braces108427773b__races
brachs134415753b__rachs
bracts105617773b__racts
branks124817383b__ranks
breaks124816423b_rea_ks
bricks144614623b__ricks
brocks145214153b__rocks
burdocks1744033burdocks
buybacks2144783buybacks
calpacks18266523calpacks
caprocks1835943caprocks
carack142113173ca_rack_
carjack2246153carjack_
carrybacks2352113carrybacks
coatracks1745403coatracks
cracks144817003__cracks
currachs1544543currachs
derricks1544433derricks
earlocks1435693earlocks
earmarks1444793earmarks
fatbacks1946003fatbacks
hardbacks2145373hardbacks
hardhacks2243703hardhacks
hardpacks2143623hardpacks
hardtacks1943803hardtacks
hatrack1638213hatrack_
hayrack1945543hayrack_
hayricks2043763hayricks
jarrahs1735453jarra_hs
lavrocks1743663lavrocks
maracas11313773ma_racas
marrams11310123marra_ms
marranos1038423marranos
narrates8312763narrates
oarlocks1445103oarlocks
parrals94414573parra_ls
paybacks2145493paybacks
racks115028853___racks
ransacks1445773ransacks
reracks132310533_reracks
retracks14149103retracks
tamaracks1743753tamaracks
tarmacs1138323tarmac_s
terraces102712253terraces
tracks124818843__tracks
untracks1437523untracks
warlocks1735363warlocks
warrants1168503warrants
wracks154711113__wracks

Search took 8 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.1561145455.1
2DLD Change Limit1461621167.26620115.9
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.46823927.6
 
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.