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

160 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
klaxon173385(None) 
claxon1536581claxon
klaxons1833261klaxons
axon115524302__axon
blazon1736762blazon
claxons1635802claxons
flacon1138632flacon
flagon1037982flagon
flaxen16518572flaxen
kaon87521022k_a_on
taxon124414662_taxon
aeon45634613__aeon
agon56531883__agon
alamo7418143alamo_
alamos8415003alamos
alan46844083ala__n
alanin6317273alanin
alation72920553alation
alexin132311483alexin
amazon1736833amazon
anon46134853__anon
axion1211316913__axion
axone125918473__axone
axons125517933__axons
azon135725053__azon
bacon95620593_bacon
ballon84117493ballon
baron78131243_baron
baton75822423_baton
beacon10511373beacon
blain75421793bla_in
blawn106813703bla_wn
blazons1836163blazons
cajon144513903_cajon
canon74725303_canon
capon95221873_capon
celadon1036913celadon
clamor1049453clamor
clan65633923cla__n
clarion9311663clarion
claro75018693claro_
claros84015113claros
classon937693classon
clon66232483cl__on
craton84517193craton
crayon114110003crayon
dalapon1044893dalapon
dalton7311273dalton
deacon9510423deacon
dragon838843dragon
elain55324703ela_in
elan46734243ela__n
elation73620453elation
elevon977953elevon
etalon648973etalon
exon117116803__exon
falcon11310293falcon
fanon84619013_fanon
flacons1238053flacons
flagons1137973flagons
flamen115215993flamen
flan76134183fla__n
flavin1239303flavin
flavone1335523flavone
flavor1236663flavor
flax147325633flax__
flaxes165015353flaxes
flaxy189012293flax_y
flexion1735073flexion
flexor1634503flexor
fluxion1735043fluxion
gallon73715813gallon
glamor958183glamor
gluon6311223gl_uon
halon86124863_halon
kabob134113933k_abob
kain85334293k_a_in
kalian10312163kalian
kalong1177703k_along
kaons95014853k_a_ons
kapok10448783k_apok
karn86129413k_a_rn
karoo92519583k_aroo
kation104315683kation
kayo116417553k_ayo_
kayos127714703k_ayos
kazoo183311533k_azoo
kelson1038153kelson
khan115819143kha__n
khazen2233773khazen
kiloton1196313kiloton
klatch15445933klatch
klavern1433003klavern
klong105310403kl__ong
kloof123812133kl_oof
koan85425033koa__n
kraken955883kraken
kroon94514483k_roon
labor75117313_labor
laden65022193_laden
ladron73413323_ladron
lagan66520343_lagan
lagoon7410483_lagoon
lain46146283_la_in
lapin75222923_lapin
lardon74415063_lardon
laten54328343_laten
lauan55216793_lauan
lawn75925633_la_wn
lax107651523_lax__
laxer125420333_laxer
laxes125430093_laxes
laxly15610103_laxly
layin84720333_layin
lemon75618183_lemon
lion46334443_l_ion
llano5910603llano_
llanos6108333llanos
logon615922313_logon
loon47344793_l_oon
macon94519953_macon
mason74820183_mason
monaxon1644913monaxon
paeon74819493_paeon
plafond1344183plafond
plain74823303pla_in
plan65833943pla__n
plasmon11257983plasmon
platan83913693platan
platen84518203platen
platoon938953platoon
pleon74216383pl_eon
plexor1535253plexor
pluton838853pluton
polaron939843polaron
racon75422143_racon
radon64620503_radon
rayon83815703_rayon
reason62616333reason
relaxin14239183relaxin
salmon84614183salmon
salon55228553_salon
saloon64418023saloon
saxony1636233_saxony
season62714903season
slain54923573sla_in
slalom888173slalom
talion6317713talion
talon55824113_talon
tauon54816583_tauon
taxol124011363_taxol
taxons134211503_taxons
telamon936523telamon
ulan46527393ula__n
wagon94312953_wagon
waxen154911813_waxen
weakon13357623weakon
weapon11288113weapon
weason93210823weason
yapon104613583_yapon

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit1127161604.92022909.8
3Display Results1601600.0463478.3
 (SQL Overall)1786911605.32633550.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.