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

124 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
boskage146541(None) 
boscage1276531boscage
boskages1565421boskages
blockage1744102blockage
bondage1138252bondage
borage93917012bo_rage
boscages1366642boscages
brockage1744742brockage
brokage1436672brokage
bulkage1435702bulkage
corkage1438372corkage
dockage1535722dockage
dosage82810002dos_age
hostage113111232hostage
lockage1436612lockage
postage103214852postage
soakage1236102soakage
assuage835683assuage
asswage1144673asswage
baggage1235633baggage
bandage11311023bandage
barrage10710843barrage
beshame1447483beshame
besiege1035413besiege
bespake15436963bespake
bisnaga1042853bisnaga
bistate9313823bistate
blockade1744033blockade
blockages1844063blockages
bondages1237893bondages
bookable16127003bookable
bookcase1643883bookcase
bookie123516003book_ie
borages103917163bo_rages
borane84620213bo_rane
borate85026153bo_rate
bosk105825733bosk___
bosker123813653bosk_er
bosket124919223bosk_et
boskets13409473boskets
boskier13309173boskier
bosks115218853bosk__s
bosky145612393bosk__y
bosque17257733bos_que
brakeage1544013brakeage
brassage1145283brassage
breakage1544183breakage
brewage1347183brewage
brockages1844783brockages
brokages1536253brokages
bulkages1535273bulkages
buoyage1344293buoyage
burgage1136633burgage
cockade1638133cockade
coinage10310553coinage
collage102813763collage
cordage11310063cordage
corkages1539103corkages
corsage1039803corsage
costae85319683costa_e
costate94019273costate
cottage104210573cottage
courage10310993courage
cowage12310673co_wage
cowhage1636303cowhage
dockages1635983dockages
dosages92310803dos_ages
dotage82711613do_tage
foggage1334113foggage
foliage1147533foliage
footage1148843footage
forage104617003fo_rage
fossae95510373fossa_e
fossate10388603fossate
homage121210603ho_mage
hostages122311693hostages
leakage1235003leakage
linkage1295963linkage
lockages1536723lockages
lovage1037353lo_vage
massage1039893massage
message1037833message
mispage12310523mispage
montage101211713montage
moorage1038743moorage
moulage1037903moulage
nonage7313683no_nage
nonwage1137163nonwage
ohmage1295063_ohmage
onstage838363onstage
outage72017533_outage
package16128013package
passage1039803passage
portage103013643portage
postages112815323postages
potage92715903po_tage
pottage103310603pottage
restage83316193restage
rootage839053rootage
roseate7613453roseate
sage55044593__s_age
sinkage1287263sinkage
skag96321513__skag_
skags104316073__skags
skate94721553__skate
soakages1336143soakages
socage91012123so_cage
soccage1236283soccage
soilage8169353soilage
stage65330193__stage
stockage1544903stockage
swage94919563__swage
tankage12257773tankage
tollage82610163tollage
tonnage8168053tonnage
towage1039833to_wage
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 Limit1340271247.42018062.9
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.87222699.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.