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

86 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
felon8461929(None) 
belon73924111belon
felons93615761felons
felony123710321felony
melon73922081melon
pelon74423211pelon
aeon45634612ae_on
azlon144312872azlon
belong93411042belong
belons84119412belons
below104617192below
beton76022062beton
celom9515682celom
clon66232482_clon
colon78630192colon
demon86520312demon
devon95113682devon
ebon66821102_ebon
elan46734242_elan
eloin55923202_eloin
eon36052082_e_on
exon117116802_exon
falcon11310292falcon
fanon84619012fanon
feign94210712feign
felid94717172felid
feline94820142feline
fell76833072fel_l
fella84918652fella
felloe93513922felloe
fellow123712742fellow
fells85327382fells
felly114922802felly
felonry13294842felonry
felt75146932fel_t
felts85324542felts
fen66851352fe__n
feod815523002fe_od
fern76129322fe_rn
fetor81214532fetor
filo76034282filo_
filos86125382filos
flan76134182f_lan
floc95922122f_loc
floe76129772f_loe
flog85523892f_log
flong95815682f_long
flop96925452f_lop
flow105924922f_low
flown116213992f_lown
fon66352272f__on
futon83113772futon
halon86124862halon
helo75332852helo_
helos84928062helos
helot85332682helot
heron85025502heron
jeon116821442je_on
jeton124815402jeton
kelson1038152kelson
lemon75618182lemon
melons84117712melons
melton8311552melton
merlon83012352merlon
meson74118312meson
nelson638422nelson
neon47026422ne_on
nylon82910512nylon
orlon5415002orlon
peon65635242pe_on
pleon74216382pleon
pylon103614002pylon
recon75624242recon
redon65424882redon
reloan6415692reloan
rewon86920572rewon
salon55228552salon
seton55223542seton
solon55026132solon
talon55824112talon
teflon937452teflon
teloi54217382teloi
telos55424522telos
telson6310292telson
tenon53320512tenon
xenon122612452xenon

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.0931921408.6
2DLD Change Limit53800861.89328420.5
3Display Results86860.0302866.7
 (SQL Overall)178691862.01688636.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.