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

219 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
soilage816935(None) 
silage72715301s_ilage
soilages9189671soilages
spoilage11195371spoilage
coinage10310552coinage
collage102813762collage
foliage1147532foliage
milage93414122_milage
moulage1037902moulage
scalage103110532scalage
silages82514442s_ilages
silane62718052s_ilane
soakage1236102soakage
socage91012122so_cage
soccage1236282soccage
soilure736232soilure
solace83415822so_lace
solate64526072so_late
spillage1146262spillage
spinage10289652spinage
spoilages12184712spoilages
sullage859912sullage
tollage82610162tollage
vorlage1136402vorlage
anlage72514233_anlage
bilge87618913_bil_ge
boilable1237793boilable
bondage1138253bondage
borage93917013bo_rage
boscage1276533boscage
boskage1465413boskage
coinages11310803coinages
collaged12279973collaged
collagen11338583collagen
collages113514243collages
collate92919683collate
college102410443college
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cottage104210573cottage
courage10310993courage
cowage12310673co_wage
cowhage1636303cowhage
dilate73220693_dilate
dockage1535723dockage
dosage82810003do_sage
dotage82711613do_tage
ensilage944713ensilage
epilate9314283epilate
foggage1334113foggage
foilable1338063foilable
folate93320393fo_late
foliaged1344673foliaged
foliages1247623foliages
foliate10513533foliate
footage1148843footage
forage104617003fo_rage
grillage1055613grillage
haulage1136913haulage
haylage1436443haylage
homage121210603ho_mage
hostage113111233hostage
image81411293__image
isolate7313923iso_late
keelage1236183keelage
linage7713403_linage
lockage1436613lockage
lovage1037353lo_vage
milages103114403_milages
mileage10299313_mileage
millage103112753millage
mirage92313653_mirage
montage101211713montage
moorage1038743moorage
moulages1138053moulages
mucilage1344203mucilage
nonage7313683no_nage
nonimage1144883nonimage
nonwage1137163nonwage
noplace1137393noplace
oblate82214743_oblate
oblige937653_oblige
ohmage1295063_ohmage
outage72017533_outage
pelage9515363_pelage
pillage103412603pillage
pipage1199143_pipage
plage84520403__plage
portage103013643portage
postage103214853postage
potage92715903po_tage
pottage103310603pottage
primage12169143primage
pupilage1343773pupilage
reimage1037913reimage
rivage1038843_rivage
rootage839053rootage
roulade857003roulade
sage55044593s___age
sailable10310563sailable
salvage1138193salvage
sausage847193sausage
savage10410173s_avage
scalade10359263scalade
scalages113010253scalages
scalare93311833scalare
scutage1036333scutage
seepage1037543seepage
selvage1136553selvage
septage1078403septage
serfage1138403serfage
sewage10310733s_ewage
shitake1455623shitake
shoelace1345293shoelace
shortage1236313shortage
sibilate1049533sibilate
siege66718443s_i_ege
signage937773signage
silanes72517163s_ilanes
silkie103313403s_ilkie
silvae92811093s_ilvae
singe65731133s_i_nge
sinkage1287263sinkage
skiplane1444833skiplane
slag55934353s__lag_
slags66525903s__lags
slake93724053s__lake
slate55438283s__late
slave84224033s__lave
slippage13103943slippage
smallage1145183smallage
smidge10378483smi_dge
smilax1535393smila_x
smilaxes1744653smilaxes
smile74823923smil__e
soakages1336143soakages
soave84219053so__ave
socager10107703so_cager
socages101012053so_cages
soccages1336383soccages
socle7419573socl__e
soigne74310033soi_gne
soignee8279133soignee
soil46138833soil___
soiled73822473soil_ed
soiling83422323soiling
soils55327983soil__s
soilures836503soilures
soiree62919483soi_ree
sola45541863so_la__
solaced102911063so_laced
solacer93011103so_lacer
solaces93116133so_laces
solan55328153so_la_n
soland75115043so_land
solano65314183so_lano
solans64122493so_lans
solar55927343so_la_r
solated83618023so_lated
solates73523853so_lates
sole46053673so_l__e
solfege1144223solfege
solgel737963so_l_gel
solidago1042773solidago
soling74226823soling_
solute64016663so_lute
solvate102710213solvate
solve85618943so_l_ve
sonicate10310933sonicate
sonlike112110713sonlike
sorbate9311733sorbate
sortilege1043033sortilege
soulmate1047193soulmate
soutane7312063soutane
spicae104313703spica_e
spicate113214193spicate
spile75230083spil__e
spillages1256083spillages
spinages11289293spinages
spinate93114813spinate
splake1259783s_plake
spoilable1345163spoilable
spoliate1039243spoliate
stage65330193s__tage
stalag7310023stalag_
stalags838643stalags
stealage946583stealage
stelae63716483stela_e
stile54931573stil__e
stockage1544903stockage
stoppage1344683stoppage
storage8310473storage
stowage1136703stowage
stylate10179773stylate
sublate9315363sublate
sullages939973sullages
swage94919563s__wage
swinge105614383swi_nge
tallage82712073tallage
thirlage1243823thirlage
tillage83111343tillage
toile54626493toil__e
tolane64316583to_lane
tollages92410193tollages
tonnage8168053tonnage
towage1039833to_wage
triage72812893tri_age
ullage739043_ullage
unitage838993unitage
village113610833village
violate10311553violate
visage1049083_visage
voila84813943voila__
voile84719723voil__e
voltage1136863voltage
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.640279204.7
2DLD Change Limit1340272197.28318402.7
3Display Results2192190.0762881.6
 (SQL Overall)1786912197.99922339.2
 
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.