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

84 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
ikons9631101(None) 
eikons1038501eikons
icons76516491icons
ikon85814951ikon_
ions46737851i_ons
irons55324131irons
aeons57624652aeons
agons66423782agons
axons125517932axons
azons146518252azons
bisons83914372bisons
boons75031912boons
cions75222852cions
clons75228132clons
cons66057692_cons
coons76737282coons
daikons12186692daikons
dons56048702_dons
ebons74316092ebons
eikon939462eikon_
eikones1137852eikones
eons46638712_eons
exons125813342exons
fons76943892_fons
frons86124042frons
gipons9389602gipons
girons75014372girons
goons65326772goons
hons77350782_hons
icon66922042icon_
icones84616382icones
idols65514132idols
ikats95311152ikats
inions64417002inions
inns46920932i_nns
ins35945602i__ns
ion36051022i_on_
iron46728462iron_
irone55126362irone
irones64724012irones
irony85015902irony
kaons95014852kaons
kens85435232_kens
kilns95112982kilns
kinos96626142kinos
kins85747902_kins
kirns95315452kirns
koans95818622_koans
koas85635092_koas
kobs105831082_kobs
kois85129392_kois
konk79320612_konk
konks84917112_konks
kops107031292_kops
kors85933012_kors
kos76944822_ko_s
koss85224812_koss
likens105613702likens
lions55923212lions
loons55731722loons
mikrons13428412mikrons
mons68152252_mons
moons75331002moons
muons75816172muons
neons55818682neons
ninons64913772ninons
nitons64614902nitons
noons54125282noons
ons36148512__ons
peons75327182peons
phons105221142phons
pinons86019942pinons
pions75826392pions
pitons85319042pitons
pons65850602_pons
poons75430962poons
skins94723462skins
sons46049552_sons
tigons74112252tigons
tons46553052_tons
toons55027532toons
udons65411462udons
wons74942042_wons
zoons144919692zoons

Search took 2 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 Limit53800841.48636204.6
3Display Results84840.0302800.0
 (SQL Overall)178691841.609111057.2
 
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.