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

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

73 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
apron731883(None) 
aprons8316991aprons
aboon74918702aboon
acorn75616622acorn
adorn64917092adorn
aeon45634612a_eon
aero45435342aero_
agon56531882a_gon
airn46433832air_n
ancon75718232ancon
anion55028812anion
anon46134852a_non
anyon85615222anyon
apian75018332apian
apo511142122ap_o_
apod78123182ap_od
aport75432172aport
apos65433822ap_os
apres75426402apres
aproned10311502aproned
argon65520592argon
arpen74418042arpen
arrow83414882arrow
arson55118832arson
avion84218342avion
axion1211316912axion
axon115524302a_xon
azlon144312872azlon
azon135725052a_zon
baron78131242baron
boron76727142boron
capon95221872cap_on
dacron94310692dacron
garron73113492garron
giron66118992giron
gyron95314622gyron
hadron102913752hadron
heron85025502heron
iron46728462_iron
ladron73413322ladron
macron103615672macron
marron83717542marron
matron83918312matron
moron76925422moron
natron64116022natron
operon8811772operon
paeon74819492paeon
pardon94618732pardon
parol74826272parol
parson83817902parson
parton84720992parton
patron84018042patron
peon65635242_peon
phon95925382_phon
pion67235292_pion
poon67341262_poon
porn65636022_porn
prion75119992_prion
pro55837262_pro_
proa66229962_proa
prod76129502_prod
prof96134662_prof
prog75729002_prog
prom87631702_prom
prone75332622_prone
prong85218112_prong
prop85932812_prop
pros65742782_pros
prow97030382_prow
spoon74719442spoon
tarpon82812802tarpon
upon65817582up_on
yapon104613582yap_on

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit53800731.72031279.1
3Display Results73730.0135615.4
 (SQL Overall)178691732.02988068.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.