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 “dalapon” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
dalapon104489(None) 
dalapons1145441dalapons
dalton7311272dal_ton
jalapin1645922jalapin
talapoin1045012talapoin
alamo7418143_alamo_
alamos8415003_alamos
alan46844083_ala__n
alanin6317273_alanin
alation72920553_alation
amazon1736833_amazon
ballon84117493bal_lon
balloon93711433balloon
blazon1736763_blazon
caldron1038153caldron
calpain11310413calpain
capon95221873__capon
celadon1036913celadon
claxon1536583_claxon
dacron94310693da_cron
daemon9279593da_emon
dahoon1039053da_hoon
daikon11217243da_ikon
daimon9259713da_imon
dalasi7610623dala_si
dalasis8810533dalasis
daltons8310403dal_tons
daman84821163dama__n
dampen114310593da_mpen
damson938063da_mson
danazol1743253danazol
dashpot1346123dashpot
deacon9510423d_eacon
dealation10313003dealation
decagon1135863decagon
decapod1335433decapod
delation92318083delation
delator83015023delator
diapason1143623diapason
dilation92215463dilation
dilator82712783dilator
dragon838843d_ragon
falcon11310293fal_con
flacon1138633_flacon
flagon1037983_flagon
galago838903galago_
galagos938143galagos
galipot1049543galipot
galleon8278713galleon
gallon73715813gal_lon
galloon82910643galloon
halation11313853halation
halazone2046093halazone
halcyon1543923halcyon
halon86124863hal__on
jalap143612473jalap__
jalapeno17131933jalapeno
jalapic1844543jalapic
jalapins1745623jalapins
jalaps15299183jalap_s
kakapo1143853kakapo_
kakapos1243673kakapos
klaxon1733853_klaxon
lapin75222923__lapin
malaprop1443073malaprop
malison939693malison
paladin101011773paladin
palapa10310673palap_a
palapas11311493palapas
paragon10311023paragon
polaron939843polaron
sabaton937713sabaton
sabayon1244233sabayon
sacaton938993sacaton
salmon84614183sal_mon
salon55228553sal__on
saloon64418023sal_oon
saltpan935303saltpan
talapoins1144703talapoins
talion6317713tal_ion
talipot949723talipot
talon55824113tal__on
tampon102911233ta_mpon
tarpon82812803ta_rpon
telamon936523telamon
weapon11288113_weapon
yapon104613583__yapon
yaupon11345493ya_upon
zacaton1845633zacaton

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 Filter1786911340270.406440125.6
2DLD Change Limit134027896.87619492.0
3Display Results89890.0461934.8
 (SQL Overall)178691897.32824384.7
 
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.