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 “cowhage” 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
cowhage163630(None) 
cowage12310671cow_age
cowhages1736111cowhages
coinage10310552coinage
collage102813762collage
cordage11310062cordage
corkage1438372corkage
corsage1039802corsage
cottage104210572cottage
courage10310992courage
cowages13310942cow_ages
cowbane1437672cowbane
cowhand1665932cowhand
cowhide1636142cowhide
towage1039832tow_age
bondage1138253bondage
borage93917013bo_rage
boscage1276533boscage
boskage1465413boskage
cabbage1446983cabbage
cage75339063c___age
carnage10311743carnage
cartage10312593cartage
chafe135117353c__hafe
change124116753c__hange
chape125221143c__hape
chare105231983c__hare
charge125114213c__harge
chase105127123c__hase
cochair1446313cochair
cockade1638133cockade
cognate10312203cognate
cohere112716993co_here
cohog117813043co_hog_
cohogs125810273co_hogs
cohune1189423co_hune
coinages11310803coinages
coliphage1743073coliphage
collaged12279973collaged
collagen11338583collagen
collages113514243collages
collate92919683collate
college102410443college
comade114415323co_made
comae97128423co_ma_e
comake144413423co_make
comanage1346343comanage
comate104124843co_mate
compare135814993compare
comrade12139213comrade
concave1439373concave
conchae143911643concha_e
conge85227593co__nge
connate9315753connate
cordages12310113cordages
cordate10315223cordate
corkages1539103corkages
corrade101111043corrade
corsages11310363corsages
cortege1098953cortege
costae85319683costa_e
costate94019273costate
cottae84615703cotta_e
cottager11306813cottager
cottages113310493cottages
cottagey14305233cottagey
courages11311393courages
couvade1335063couvade
coverage1438733coverage
coward12411673cow_ard
cowbanes1537423cowbanes
cowhands1765263cowhands
cowherb1735103cowherb
cowherd1636953cowherd
cowhided1843753cowhided
cowhides1736013cowhides
cowing124526323cowing_
cowman13910373cowma_n
cowpat13312033cowpa_t
cowpats1437713cowpats
cowpie133511513cow_pie
cowpoke1835103cowpoke
cowrie113814283cow_rie
cowrite123612683cowrite
cowrote12289673cowrote
coxae146115183co_xa_e
cozenage2094783cozenage
cubage1178273c_ubage
cuttage10318343cuttage
dockage1535723dockage
dosage82810003do_sage
dotage82711613do_tage
dowager1245803dow_ager
ecotage1036883eco_tage
flowage1435723flow_age
foggage1334113foggage
foliage1147533foliage
footage1148843footage
forage104617003fo_rage
homage121210603ho_mage
hostage113111233hostage
lockage1436613lockage
lovage1037353lo_vage
montage101211713montage
moorage1038743moorage
moulage1037903moulage
nonage7313683no_nage
nonwage1137163nonwage
nowhere1337213nowhere
ohmage1295063_ohmage
outage72017533_outage
pawnage1335873pawnage
phage115113673__phage
portage103013643portage
postage103214853postage
potage92715903po_tage
pottage103310603pottage
prophage1649433prophage
rootage839053rootage
roughage1344423roughage
sewage10310733sew_age
soakage1236103soakage
socage91012123so_cage
soccage1236283soccage
soilage8169353soilage
stowage1136703stow_age
swage94919563_sw_age
tollage82610163tollage
tonnage8168053tonnage
towages1139233tow_ages
towhee122613883towh_ee
voltage1136863voltage
vorlage1136403vorlage
voyage1335473vo_yage
wage84834083__w_age
whale115517433__whale
wordage1236503wordage

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271377.50017870.3
3Display Results1371370.1101245.5
 (SQL Overall)1786911378.03322244.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.