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

151 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
harpoon123831(None) 
harpoons1337481harpoons
cardoon104813812cardoon
carpool1139222carpool
cartoon94114462cartoon
harpin113614382harp_in
harpooned1544322harpooned
harpooner1444332harpooner
jargoon1545192jargoon
lampoon11267192lampoon
lardoon83410372lardoon
maroon83118202mar_oon
tarpon82812802tarp_on
aboon74918703_a_boon
apron7318833_a_pron
archon11311753_archon
argon65520593_ar_gon
arpen74418043_arp_en
arson55118833_ar_son
aswoon947013_aswoon
baboon103613913ba_boon
balloon93711433balloon
baron78131243bar__on
barroom1139373barroom
baryon111211613bar_yon
baryton1246003baryton
bassoon937613bassoon
bradoon1037353bradoon
campion133011413campion
capon95221873ca_p_on
carbon104919043car_bon
cardon94120853car_don
cardoons113411943cardoons
carpools1237883carpools
carport11316033carport
carrion9312673carrion
carryon1237033carryon
carton84522663car_ton
cartoons104012803cartoons
cartoony13377403cartoony
champion17276353champion
charpoy1735713charp_oy
charpoys1834533charpoys
crampoon1444543crampoon
croon75522783_cr_oon
dahoon1039053da_hoon
dragoon935283dragoon
earphone1348253earphone
gaboon93211773ga_boon
gadroon938173gadroon
galloon82910643galloon
garcon92912483gar_con
garron73113493gar_ron
haboob1377883ha_boob
hadron102913753ha_dron
hagborn1344953hagborn
hagdon1188283ha_gdon
hairpin1245413hairp_in
halcyon1543923halcyon
halloo95118973halloo_
halloos103716743halloos
halon86124863ha__lon
haplont12412563ha_plont
happen134812193ha_ppen
hapten115312983ha_pten
harbor11410723har_bor
harbors12412413harbors
harbour1247053harbour
hardboot1446943hardboot
harden105718533har_den
hardpan1336443hardpan
hardtop1345053hardtop
hardwood16155743hardwood
haricot12311963haricot
harijan1735783harijan
harken135116343har_ken
harlot94422803har_lot
harlots103413293harlots
harmin113117393har_min
harmony1538173harmony
harp96134293harp___
harped124418403harp_ed
harper115018403harp_er
harpers124916203harpers
harpies123818313harpies
harping134118383harping
harpins123615703harpins
harpist12312353harpist
harpooners1543813harpooners
harpooning1644483harpooning
harps105926873harp__s
harpy136418213harp__y
harrow122610773har_row
harrows132611033harrows
harshen1339283harshen
hatpin112610613hatp_in
hereon93914363her_eon
heroin94420593her_oin
heron85025503her__on
hoopoo1198753hoopoo_
hoopoos1298543hoopoos
horizon1955763horizon
jargon1448823jar_gon
jargoons1644663jargoons
karoo92519583kar_oo_
karoos102415803kar_oos
karroo10410013karroo_
karroos1139313karroos
kroon94514483_kr_oon
lagoon7410483la_goon
lampion11278303lampion
lampoons12266873lampoons
lardon74415063lar_don
lardoons9398483lardoons
madzoon1996063madzoon
maroons92615553mar_oons
marplot1149673marplot
marron83717543mar_ron
matzoon1896473matzoon
paragon10311023paragon
pardon94618733par_don
parson83817903par_son
parton84720993par_ton
partook1337313partook
patroon92811973patroon
poon67341263___poon
raccoon1176163raccoon
racoon83814473ra_coon
rampion11298583rampion
ratoon64417373ra_toon
rattoon7359243rattoon
saloon64418023sa_loon
shalloon1145683shalloon
shampoo1435373shampoo_
shampoos1544603shampoos
sharpen12389723sharp_en
spoon74719443__spoon
tampion11298663tampion
tampon102911233tamp_on
taproom1147963taproom
taproot9412673taproot
tardyon1134673tardyon
tarpan82814293tarp_an
tarpons92612213tarpons
teaspoon1044423teaspoon
vanpool1243763vanpool
varoom11411413var_oom
warison1037083warison
warworn1357353warworn
yapon104613583ya_p_on
yaupon11345493yaup_on

Search took 7 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.406440125.6
2DLD Change Limit1340271516.15621771.8
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.60827041.6
 
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.