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

167 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
herbage133700(None) 
herbaged1554521herbaged
herbages1437081herbages
garbage1138052garbage
henbane1237352henbane
herbal112513492herba_l
herbals122710602herbals
heritage1246532heritage
hermae115314472herma_e
serfage1138402serfage
verbiage1444542verbiage
acerbate1247533acerbate
acreage1037833acreage
aerate64830553aer_ate
airbag956963airbag_
airbags1036293airbags
ambage11510593_ambage
average1158853aver_age
barbate11314543barbate
barrage10710843barrage
berake124216083ber_ake
berate84729023ber_ate
bereave1258353bereave
borage93917013bor_age
brewage1347183brewage
burgage1136633burgage
cabbage1446983cabbage
carnage10311743carnage
cartage10312593cartage
cerate84829463cer_ate
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cubage1178273_cubage
debag94212303de_bag_
debags104211063de_bags
debase94014473de_base
debate94419193de_bate
degage92711383de_gage
derange939813derange
derate74531233der_ate
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
erase54925493_er_ase
ergate7315143_ergate
ferbam1339003ferba_m
ferbams1435743ferbams
feriae95618603feria_e
fermate122813003fermate
ferrate103014033ferrate
ferriage1245463ferriage
forage104616993for_age
forbade13259103forbade
forbare122310513forbare
garage8314513gar_age
garbages1238183garbages
garbagey1543373garbagey
garbagy1444243garbagy
germane1049663germane
harborage1544653harborage
haulage1136913haulage
haylage1436443haylage
hearable131611603hearable
heave114521813he__ave
hebe96424703he_b__e
hebraize2244453hebraize
hectare1238463hectare
hedge105317333he__dge
hektare1435503hektare
helotage1245713helotage
henbanes1336563henbanes
henge94819823he__nge
heptane1238363heptane
herald10311343her_ald
herb94730963herb___
herbaria1346093herbaria
herbed123513453herb_ed
herbier1239593herbier
herblike1735883herblike
herbs105520503herb__s
herby134715313herb__y
here76447103her___e
hereat93527413herea_t
heritages1346713heritages
herma105318883herma__
hermai118912843herma_i
hermitage1543863hermitage
herniae1039043herniae
herniate1148113herniate
heroine103517483heroine
heroize193210963heroize
hewable15177823hewable
hexade17438903he_xade
hexane16379533he_xane
hirable121612313hirable
homage121210603h_omage
hostage113111233hostage
keelage1236183keelage
leafage1194573leafage
leakage1235003leakage
meltage1037953meltage
menage93216543me_nage
merge84523683mer__ge
message1037833message
metage93114453me_tage
mirage92313653mir_age
nervate1039523nervate
overage11514053over_age
overbake17129803overbake
parbake1538353parbake
peage84723563pe__age
peerage1089803peerage
pelage9515363pe_lage
peonage1048723peonage
percale11314083percale
pervade1337023pervade
portage103013643portage
prebade12310283prebade
prebake1539093prebake
presage10312293presage
rage55742353__r_age
rebate84424103re_bate
reimage1037913reimage
restage83316183restage
rheobase1342623rheobase
seabag938473seabag_
seabags1037483seabags
seepage1037543seepage
selvage1136553selvage
septage1078403septage
serape84818413ser_ape
serfages1238233serfages
serge64727463ser__ge
seriate73722473seriate
serrate73017533serrate
sewage10310733se_wage
shortage1236303shortage
sorbate9311733sorbate
surbase939793surbase
teenage8108053teenage
tentage81010643tentage
ternate7415483ternate
terrace93311833terrace
terrae62915203terra_e
terrane72814223terrane
thenage11107833the_nage
thermae125310493therma_e
thirlage1243813thirlage
triage72812893_triage
umbrage1236723umbrage
urbane82211383_urbane
ventage11109623ventage
verbal112513663verba_l
verbals121910733verbals
verbiages1544673verbiages
verbile1249863verbile
verbose1237753verbose
verge93419833ver__ge
vorlage1136403vorlage
warpage1336403warpage
webpage1543133webpage
wharfage1842213wharfage
wordage1236503wordage
yardage1235733yardage
yerba101010763yerba__
yerbas11119293yerba_s

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.1561145455.1
2DLD Change Limit1340271677.00019146.7
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.