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

223 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
tollage8261016(None) 
collage102813761collage
tallage82712071tallage
tillage83111341tillage
tollages92410191tollages
collaged12279972collaged
collagen11338582collagen
collages113514242collages
collate92919682collate
college102410442college
foliage1147532foliage
millage103112752millage
moulage1037902moulage
pillage103412602pillage
soilage8169352soilage
sullage859912sullage
tallaged10257922tallaged
tallages92312002tallages
tillages93011262tillages
tolane64316582to_lane
tollgate946252tollgate
toluate7159342toluate
tonnage8168052tonnage
towage1039832to_wage
ullage739042_ullage
village113610832village
voltage1136862voltage
vorlage1136402vorlage
abollae936943abolla_e
allege74314653_allege
anlage72514233_anlage
ballade104012563ballade
bollard103210503bollard
bondage1138253bondage
borage93917013bo_rage
boscage1276533boscage
boskage1465413boskage
bulkage1435703bulkage
bullace113410673bullace
bullae83416163bulla_e
bullate93415073bullate
cellae84915933cella_e
coinage10310553coinage
collagens12256043collagens
collapse1244273collapse
collar83816173colla_r
collard103712923collard
collared113211143collared
collaret103116703collaret
collars93816573collars
collated113615063collated
collates103019143collates
colleague1243093colleague
colleger11227933colleger
colleges112410523colleges
collide103214793collide
collie83621993coll_ie
collogue1145473collogue
collude10337993collude
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cottage104210573cottage
courage10310993courage
cowage12310673co_wage
cowhage1636303cowhage
diallage1045233diallage
dockage1535723dockage
dollar74110983dolla_r
dollars83311023dollars
dosage82810003do_sage
dotage82711613do_tage
fellate10313433fellate
flotage1136683flotage
flowage1435723flowage
foggage1334113foggage
folate93320393fo_late
foliaged1344673foliaged
foliages1247623foliages
foliate10513533foliate
footage1148843footage
forage104617003fo_rage
gallate83417133gallate
grillage1055613grillage
haulage1136913haulage
haylage1436443haylage
holla84918493holla__
hollaed11359853hollaed
holland11349473holland
hollas94616903holla_s
homage121210603ho_mage
hostage113111233hostage
keelage1236183keelage
lockage1436613lockage
lovage1037353lo_vage
meltage1037953meltage
milage93414123_milage
mileage10299313mileage
millages113212903millages
mollah11319453molla_h
mollahs12328283mollahs
mollie83517103moll_ie
montage101211713montage
moorage1038743moorage
moulages1138053moulages
nonage7313683no_nage
nonwage1137163nonwage
noplace1137393noplace
oblate82214743_oblate
oblige937653_oblige
ohmage1295063_ohmage
oleate6318883_oleate
olla44821173_olla__
ollas54218283_olla_s
outage72017533_outage
pelage9515363_pelage
pillaged12298093pillaged
pillager11278553pillager
pillages113012613pillages
plage84520403__plage
poleaxe1656303poleaxe
pollack1567333pollack
pollard103511143pollard
pollee83623273poll_ee
pollute937383pollute
portage103013643portage
postage103214853postage
potage92715903po_tage
pottage103310603pottage
rootage839053rootage
roulade857003roulade
salvage1138193salvage
scalage103110533scalage
selvage1136553selvage
silage72715303_silage
smallage1145183smallage
soakage1236103soakage
socage91012123so_cage
soccage1236283soccage
soilages9189673soilages
solace83415823so_lace
solate64526073so_late
solfege1144223solfege
solvate102710213solvate
spillage1146263spillage
spoilage11195373spoilage
stealage946583stealage
stellate8310503stellate
stockage1544903stockage
stoppage1344683stoppage
storage8310473sto_rage
stowage1136703sto_wage
sullages939973sullages
tankage12257773tankage
tannage8209583tannage
teenage8108053teenage
telae54323293t_ela_e
tellable10169773tellable
telltale844423telltale
tentage81010643tentage
thanage11117943thanage
thenage11107843thenage
thirlage1243823thirlage
tillable10159753tillable
tillite7313563tillite
toccate1138773toccate
toelike11149823toelike
toeplate1047613toeplate
togae67020113to_ga_e
togate74515683to_gate
toile54626493toil__e
tola45236333to_la__
tolan55124013to_la_n
tolanes74216313to_lanes
tolans64319273to_lans
tolar55524113to_la_r
tolars64817943to_lars
tolas54532773to_la_s
tole46052903to_l__e
tolerate8312323tolerate
toling73926123toling_
toll45535263toll___
tollbar945453tollbar
tollbars1045443tollbars
tolled73819033toll_ed
toller63819443toll_er
tollers73217463tollers
tollgates1046053tollgates
tolling83418563tolling
tollman935863tollman
tollmen935733tollmen
tolls54728433toll__s
tollway1344793tollway
tollways1444133tollways
toluates8138903toluates
toluene736463toluene
toluide835263toluide
toluole736113toluole
tonnages9187873tonnages
topline92313183topline
torsade837593torsade
torulae758553torula_e
towages1139233to_wages
towline102911543towline
towplane1345313towplane
toylike14157243toylike
treillage1043673treillage
triage72812893t_riage
tulle54019933tull__e
tunnage8166373tunnage
tutelage944063tutelage
ullaged937033_ullaged
ullages838953_ullages
vallate103016563vallate
villae95615383villa_e
villager12267513villager
villages123010603villages
volplane1344313volplane
voltages1237253voltages
volvate13317993volvate
vorlages1236033vorlages
voyage1335473vo_yage
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.440406115.9
2DLD Change Limit1340272238.26316220.1
3Display Results2232230.1731289.0
 (SQL Overall)1786912238.87620131.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.