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

201 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
voltage113686(None) 
voltages1237251voltages
collage102813752collage
cottage104210572cottage
dotage82711612do_tage
flotage1136672flotage
foliage1147532foliage
footage1148832footage
hostage113111232hostage
meltage1037952meltage
montage101211712montage
outage72017532_outage
portage103013642portage
postage103214852postage
potage92715902po_tage
pottage103310602pottage
rootage839042rootage
tollage82610162tollage
vantage11109892vantage
ventage11109622ventage
village113610822village
vintage11128142vintage
volta85215622volta__
voltaic1245452voltaic
volte85321302volt__e
volvate13317992volvate
vorlage1136402vorlage
voyage1335472vo_yage
anlage72514223anl_age
aortae65115473aorta_e
bondage1138253bondage
borage93917013bo_rage
boscage1276533boscage
boskage1465413boskage
bulkage1435703bulkage
cartage10312593cartage
coinage10310553coinage
collaged12279963collaged
collagen11338563collagen
collages113514233collages
collate92919683collate
college102410433college
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cortege1098943cortege
costae85319683costa_e
costate94019273costate
cottae84615703cotta_e
cottager11306803cottager
cottages113310493cottages
cottagey14305233cottagey
courage10310993courage
cowage12310663co_wage
cowhage1636293cowhage
cuttage10318343cuttage
dockage1535723dockage
dosage82810003do_sage
dotages92311793do_tages
ecotage1036883ecotage
floatage1244403floatage
flotages1237153flotages
flowage1435723flowage
foggage1334113foggage
folate93320393fol_ate
foliaged1344673foliaged
foliages1247623foliages
foliate10513533foliate
folktale1542873folktale
footages1239043footages
forage104616993fo_rage
frontage1296243frontage
frottage1245073frottage
helotage1245713helotage
homage121210603ho_mage
hostages122311693hostages
lockage1436613lockage
lovage1037353lo_vage
maltase938903maltase
meltages1148243meltages
metage93114453_metage
milage93414123mil_age
mileage10299313mileage
millage103112743millage
mintage101110123mintage
montaged12107763montaged
montages111412183montages
montane91313623montane
moorage1038733moorage
mortgage1244213mortgage
moulage1037903moulage
multiage1147983multiage
nonage7313683no_nage
nonwage1137163nonwage
notate63217863no_tate
octane81411633_octane
octave11157343_octave
ohmage1295063_ohmage
oleate6318883_oleate
onstage838363onstage
outages82317323_outages
outate62923403_outate
outrage82616883_outrage
overage11514053overage
pelage9515363pel_age
peltate92013773peltate
pillage103412593pillage
pilotage1145373pilotage
plage84520403_pl_age
plottage1144433plottage
poleaxe1656303poleaxe
portaged12228463portaged
portages112613223portages
postages112815323postages
potages102416423po_tages
pottages112910453pottages
restage83316183restage
rootages939093rootages
rotate63320343ro_tate
salvage1138193salvage
scutage1036333scutage
selvage1136553selvage
septage1078403septage
shortage1236303shortage
silage72715303sil_age
soakage1236103soakage
socage91012123so_cage
soccage1236283soccage
soilage8169353soilage
solace83415823sol_ace
solate64526073sol_ate
solfege1144223solfege
solvate102710213solvate
soutane7312063soutane
stage65330193__stage
sullage859913sullage
tallage82712073tallage
tentage81010643tentage
tillage83111333tillage
tolane64316583tol_ane
tollages92410193tollages
toluate7159343toluate
tonnage8168053tonnage
towage1039833to_wage
ullage739043_ullage
unitage838993unitage
upstage10167443upstage
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
vantages12119023vantages
velate93720143vel_ate
ventages12119763ventages
vestige1137433vestige
villae95615383villa_e
villager12267503villager
villages123010593villages
vintager12104823vintager
vintages12118273vintages
violate10311553viol_ate
visage1049083v_isage
vitae84217633v_ita_e
vittae93910993vitta_e
vittate10409723vittate
volant9316323vol_ant
volante1038513volante
volar86917413vol_a_r
volatile1146433volatile
volcano1244613volcano
vole75236983vol___e
voling103918013voling_
volitant1147863volitant
volitive1446893volitive
volplane1344313volplane
volt76439533volt___
voltaism1344813voltaism
voltes94915583volt_es
volti84915963volt__i
volts85421293volt__s
voluble1244503voluble
volume11358273vol_ume
volute93912763vol_ute
volva11399003volva__
volvas12447993volva_s
vorlages1236033vorlages
votable122111373vo_table
votary12248333vo_tary
vote74728623vo_t__e
votive12348933vo_tive
voyaged1533513vo_yaged
voyager1433513vo_yager
voyages1435703vo_yages
vulgate11388433vulgate
vulture1036763vulture
vulvae12438033vulva_e
vulvate13388323vulvate
waftage14115323waftage
wantage11119623wantage
wastage11109253wastage
wattage1186983wattage
wordage1236503wordage

Search took 7 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 Limit1340272016.51320578.4
3Display Results2012010.0802512.5
 (SQL Overall)1786912016.74926476.7
 
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.