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

142 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
boscage127653(None) 
boscages1366641boscages
boskage1465411boskage
bondage1138252bondage
borage93917012bo_rage
boskages1565422boskages
dosage82810002dos_age
hostage113111232hostage
postage103214852postage
socage91012122so_cage
soccage1236282soccage
assuage835683assuage
asswage1144673asswage
baccae12119703bacca_e
baccate131011263baccate
baggage1235633baggage
bandage11311023bandage
barrage10710853barrage
bascule1136573bascule
became123213163b_ecame
beshame1447483beshame
besiege1035413besiege
bespake15436963bespake
bioscope1446483bioscope
birdcage1443513birdcage
bisnaga1042853bisnaga
bistate9313823bistate
blockage1744103blockage
bobcat12411253bobca_t
bobcats1335993bobcats
bocce114313113bo_c_ce
boccie123311453bo_ccie
boche124216953bo_c_he
bondages1237893bondages
bookcase1643883bookcase
borages103917163bo_rages
borane84620213bo_rane
borate85026153bo_rate
bosque17257733bos_que
bouchee143313543bouchee
boucle103712783bouc_le
boxcar1734753boxca_r
boxcars1834773boxcars
brassage1145283brassage
brewage1347183brewage
brocade1238533brocade
brockage1744743brockage
brokage1436673brokage
bulkage1435703bulkage
buoyage1344293buoyage
burgage1136633burgage
cage75339063___cage
cascade12118603cascade
coinage10310553coinage
collage102813763collage
concave1439373concave
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
costae85319683costa_e
costate94019273costate
cottage104210573cottage
courage10310993courage
cowage12310673co_wage
cowhage1636303cowhage
discase102912863discase
dockage1535723dockage
dosages92310803dos_ages
dotage82711613do_tage
encage93713503_encage
escape103811663_escape
escuage1035113_escuage
foggage1334113foggage
foliage1147533foliage
footage1148843footage
forage104617003fo_rage
fossae95510373fossa_e
fossate10388603fossate
hoecake1645203hoecake
homage121210603ho_mage
hostages122311693hostages
hotcake1644543hotcake
incage93513623_incage
inscape1138023inscape
locale83915653lo_cale
locate83919843lo_cate
lockage1436613lockage
lovage1037353lo_vage
massage1039893massage
message1037833message
mispage12310523mispage
montage101211713montage
moorage1038743moorage
moschate1546593moschate
moulage1037903moulage
muscae10410673musca_e
nonage7313683no_nage
nonwage1137163nonwage
obscene1145243obscene
obscure1145333obscure
ohmage1295063_ohmage
onstage838363onstage
oscine8311563_oscine
oscule838193_oscule
outage72017533_outage
passage1039803passage
portage103013643portage
postages112815323postages
potage92715903po_tage
pottage103310603pottage
rescale93215483rescale
restage83316193restage
rootage839053rootage
roscoe839763rosc_oe
roseate7613453roseate
sage55044593__s_age
scag76626893__scag_
scags85520973__scags
scale74629143__scale
scape96921843__scape
scare75334463__scare
soakage1236103soakage
socager10107703so_cager
socages101012053so_cages
soccages1336383soccages
soilage8169353soilage
stage65330193__stage
swage94919563__swage
toccate1138773toccate
tollage82610163tollage
tonnage8168053tonnage
towage1039833to_wage
uncage93014873_uncage
upscale11136323upscale
upstage10167443upstage
usage6410213_us_age
visage1049083vis_age
voltage1136863voltage
vorlage1136403vorlage
voyage1335473vo_yage
wastage11109253wastage
wordage1236503wordage

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271427.28318402.7
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.74923059.9
 
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.