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

105 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
foliaged134467(None) 
foliage1147531foliage_
foliages1247621foliages
foliated1249911foliated
collaged12279972collaged
filiated12610082filiated
foliate10513532foliate_
foliates11412752foliates
folioed1138032foli_oed
foraged124812282fo_raged
ciliated11510953ciliated
clinged113310093_clinged
collage102813763collage_
collagen11338573collagen
collages113514243collages
collared113211143collared
collated113615063collated
defoliated1545833defoliated
exfoliated2163393exfoliated
falcated1438473falcated
fellated1239563fellated
fidged124610933f__idged
figged124013893f__igged
filiate10414233filiate_
filiates11412663filiates
finialed1255503finialed
flagged13459633f_lagged
flailed1137303f_lailed
flaked144715653f_l_aked
flamed124618973f_l_amed
flanged123810843f_langed
flared105317603f_l_ared
flawed134712723f_l_awed
flayed134414053f_l_ayed
fledged13417863f_ledged
flicked174610673f_licked
flied96519433f_li__ed
flinger113710513f_linger
flinted114411893f_linted
flipped15358513f_lipped
flirted11428673f_lirted
flited104616583f_li_ted
flitted114011643f_litted
floated113312703f_loated
flogged13528803f_logged
floriated1347023floriated
flotage1136683flotage_
flotages1237163flotages
flowage1435723flowage_
flowages1535733flowages
foaled104515963fo__aled
foamed126014403fo__amed
foggage1334113foggage_
foggages1434213foggages
fogged125518373fo__gged
foiled104618403fo_i_led
foined105915013fo_i_ned
foisted113210603fo_isted
folate93320393fol_ate_
folates103218453fol_ates
folded114212793fol__ded
folia83618933folia___
foliar93210973folia__r
foliose10378013foliose_
followed15146273followed
footage1148843footage_
footages1239053footages
forage104617003fo_rage_
forager114412563fo_rager
forages114217283fo_rages
forayed14368593fo_rayed
forged115519323fo__rged
foveated1536293foveated
frigged13439053f_rigged
fringed123611523f_ringed
frolicked1942613frolicked
goliard936073golia_rd
holidayed1742163holidayed
hollaed11359853holla_ed
homaged1497413ho_maged
montaged12107763montaged
obliged1134983obli_ged
opiated1039483_opiated
pillaged12298093pillaged
poleaxed1854823poleaxed
policed123212233poli_ced
polished1468433polished
polkaed1435323polka_ed
portaged12228463portaged
salvaged1335363salvaged
selvaged1334343selvaged
soilage8169353soilage_
soilages9189673soilages
solaced102911063sol_aced
solated83618023sol_ated
solvated12237443solvated
spoliated1246913spoliated
tallaged10257923tallaged
tollage82610163tollage_
tollages92410193tollages
triaged92810443_triaged
ullaged937033_ullaged
voltage1136863voltage_
voltages1237253voltages
voyaged1533513vo_yaged

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621057.47019566.5
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.95222471.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.