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

204 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
foliage114753(None) 
foliaged1344671foliaged
foliages1247621foliages
foliate10513531foliate
collage102813752collage
filiate10414232filiate
flotage1136672flotage
flowage1435722flowage
foggage1334112foggage
folate93320392fol_ate
folia83618932folia__
foliar93210972folia_r
foliated1249912foliated
foliates11412752foliates
foliose10378012foliose
footage1148832footage
forage104616992fo_rage
soilage8169352soilage
tollage82610162tollage
voltage1136862voltage
anlage72514223anl_age
bifoliate1444313bifoliate
bolide9515563boli_de
bondage1138253bondage
borage93917013bo_rage
boscage1276533boscage
boskage1465413boskage
bulkage1435703bulkage
ciliate9514593ciliate
coinage10310553coinage
coliphage1743073coliphage
collaged12279963collaged
collagen11338563collagen
collages113514233collages
collate92919683collate
college102410433college
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cottage104210573cottage
courage10310993courage
cowage12310663co_wage
cowhage1636293cowhage
defoliate1346993defoliate
dockage1535723dockage
doling84923133doling_
dosage82810003do_sage
dotage82711613do_tage
eolian6312593eolia_n
exfoliate1954133exfoliate
faciae112913413facia_e
falcate12311613falcate
feline94820143feli_ne
fellate10313433fellate
feriae95618603feria_e
ferriage1245463ferriage
fidge104516053f__idge
filial93013253filia_l
filiated12610083filiated
filiates11412653filiates
filibeg1353383filibeg
filing103823763filing_
filings115213073filings
flag87427083f_l_ag_
flags95321283f_l_ags
flake125119973f_l_ake
flame105124443f_l_ame
flange103411973f_lange
flare84823633f_l_are
fledge11439293f_ledge
fling97023513f_ling_
flinger113710503f_linger
flings106715283f_lings
flite85424963f_li_te
floatage1244403floatage
floorage1275083floorage
florae94713883flora_e
flotages1237153flotages
flowages1535733flowages
foaling113515843foaling_
foggages1434213foggages
fogie96719003fogi__e
foible11410383fo_ible
foilable1338063foilable
foiling113317653foiling_
folates103218453fol_ates
foldable1437133foldable
folding123912443folding_
folic105319323foli__c
folio83820873foli__o
folioed1138033folioed
foliolate1244873foliolate
folios93915463foli_os
folious103710723folious
folium11310453foli_um
foliums1237173foliums
folkie13369613fol_kie
folktale1542873folktale
follicle1344393follicle
fomite113314073fomi_te
fooling113117373fooling_
footages1239043footages
foraged124812273fo_raged
forager114412553fo_rager
forages114217273fo_rages
forbade13259103forbade
forbare122310513forbare
forgave1435853forgave
forge95126943fo__rge
formate123115093formate
forsake1436533forsake
fossae95510373fossa_e
fossate10388603fossate
fouling113315373fouling_
foulings12327943foulings
foveae1237563fovea_e
foveate1338363foveate
fowling143713113fowling_
fowlings15377243fowlings
foxing175012433foxing_
foxings18446963foxings
foxlike21226223foxli_ke
fridge11379253f_ridge
fringe104013953f_ringe
fromage1336753fromage
frontage1296243frontage
frottage1245073frottage
fruitage1244343fruitage
goliard936073goliard
goliath1145933goliath
holing104025073holing_
homage121210603ho_mage
hostage113111233hostage
iolite63221973ioli_te
liane54720663__liane
liege65314433__liege
linage7713403__linage
lockage1436613lockage
lovage1037353lo_vage
meltage1037953meltage
milage93414123mil_age
mileage10299313mileage
millage103112743millage
moline84422033moli_ne
montage101211713montage
moorage1038733moorage
moulage1037903moulage
multiage1147983multiage
nonage7313683no_nage
nonimage1144883nonimage
nonwage1137163nonwage
oblige937653obli_ge
ohmage1295063_ohmage
oleate6318883_oleate
olingo736933_olingo
olive84817153_oli_ve
oolite63319603ooli_te
opiate8513463_opiate
outage72017533_outage
pelage9515363pel_age
pillage103412593pillage
plage84520403_pl_age
poleaxe1656303poleaxe
police102918563poli_ce
poling93526503poling_
polite83625073poli_te
portage103013643portage
postage103214853postage
potage92715903po_tage
pottage103310603pottage
rootage839043rootage
salvage1138193salvage
selvage1136553selvage
silage72715303sil_age
soakage1236103soakage
socage91012123so_cage
soccage1236283soccage
soilages9189673soilages
solace83415823sol_ace
solate64526073sol_ate
solfege1144223solfege
solidago1042773solidago
soling74226823soling_
solvate102710213solvate
spoilage11195373spoilage
spoliate1039243spoliate
sullage859913sullage
tallage82712073tallage
tillage83111333tillage
tolane64316583tol_ane
toling73926123toling_
tollages92410193tollages
toluate7159343toluate
tonnage8168053tonnage
towage1039833to_wage
triage72812893_triage
ullage739043_ullage
village113610823village
voling103918023voling_
voltages1237253voltages
volvate13317993volvate
vorlage1136403vorlage
voyage1335473vo_yage
wordage1236503wordage

Search took 10 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.1401276364.3
2DLD Change Limit1340272048.81015213.1
3Display Results2042040.0802550.0
 (SQL Overall)1786912049.03019788.6
 
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.