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

113 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
lampoon1126719(None) 
lampion11278301lampion
lampoons12266861lampoons
campion133011412campion
crampoon1444542crampoon
harpoon1238312harpoon
lagoon7410482la_goon
lampions12277972lampions
lampooned1443572lampooned
lampooner1343362lampooner
lardoon83410372lardoon
rampion11298582rampion
tampion11298662tampion
tampon102911232tamp_on
aboon74918703_a_boon
amazon1736833_amazon
ammono1047373_ammono
amnion84812053_amnion
apron7318833_a_pron
aswoon947013_aswoon
baboon103613913ba_boon
balloon93711433balloon
bamboo12310013bamboo_
bamboos1348753bamboos
bassoon937613bassoon
camion103917193cam_ion
camphol1645793camphol
camphor1636133camphor
campions143511293campions
campo115219763camp_o_
campong14318123campong
campos125217953camp_os
campout13412853campout
capon95221873ca_p_on
cardoon104813813cardoon
carpool1139223carpool
cartoon94114463cartoon
champion17276353champion
clampdown1951843clampdown
crampon1336943cramp_on
crampoons1544063crampoons
dahoon1039053da_hoon
dampen114310593damp_en
damson938063dam_son
gaboon93211773ga_boon
gadroon938173gadroon
galloon82910643galloon
gammon1138903gam_mon
harpoons1337473harpoons
jargoon1545193jargoon
kampong16294933kampong
ladhood1246473ladhood
ladron73413323la_dron
lagoons839253la_goons
lambkin1545243lambkin
laminin939973laminin
lamp86233823lamp___
lampad114510033lamp_ad
lampads12477623lampads
lampas106615953lamp_as
lamped114017543lamp_ed
lampers113817333lampers
lamping123116003lamping
lampooners1442903lampooners
lampoonery1751643lampoonery
lampooning1543533lampooning
lamppost1443513lamppost
lamprey1434863lamprey
lamps95624833lamp__s
lapdog1034443la_pdog
lapin75222923la_p_in
laptop1076813la_ptop
lardon74415063la_rdon
lardoons9398483lardoons
lawbook1644033lawbook
lemon75618183lem__on
lepton82510803l_epton
limacon1144143limacon
limpkin1534223limpkin
loon47344793l___oon
lumpen104010663lump_en
madzoon1996063madzoon
mammon939643mam_mon
maroon83118203ma_roon
matzoon1896473matzoon
moon67140813__m_oon
pampean1335543pampean
patroon92811973patroon
platoon938953pla_toon
pompon1238943pomp_on
poon67341263___poon
raccoon1176163raccoon
racoon83814473ra_coon
rampions12248023rampions
rampole1139693rampole
ramson8310463ram_son
ratoon64417373ra_toon
rattoon7359243rattoon
saloon64418023sa_loon
sampan102511893samp_an
shampoo1435373shampoo_
shampoos1544603shampoos
simoon858063sim_oon
spoon74719443__spoon
tampan102512323tamp_an
tampions12358113tampions
tampons112711553tampons
tarpon82812803tarp_on
teaspoon1044413teaspoon
tompion11247103tompion
vanpool1243763vanpool
yapon104613583ya_p_on
yaupon11345493yaup_on

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.1561145455.1
2DLD Change Limit1340271137.98316789.1
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.18521831.5
 
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.