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

267 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
waggons123550(None) 
waggon1136391waggon_
wagons103911211wa_gons
agons66423782_a_gons
argons75018202_argons
faggots1234852faggots
hagdons1258522hagdons
jargons1558202jargons
lagoons839252lagoons
maggots1136552maggots
waggers124613082waggers
wagging133313352wagging
waggles123812002waggles
waggoned1443252waggoned
waggoner1343422waggoner
waggoners1443182waggoners
wagon94312952wa_gon_
wangans1149502wangans
wanguns1135022wanguns
wanions104011372wanions
wantons103713012wantons
wigeons1136982wigeons
aeons57624653_a_eons
aggers85817793_aggers
aggies83515513_aggies
aggros836543_aggros
agios65919863_agio_s
agon56531883_a_gon_
agone65924553_a_gone
agones75719863_a_gones
agony96415653_a_gony
algins74816433_algins
algors7312553_algors
anions64123033_anions
anyons94513503_anyons
aprons8316993_aprons
argols74514613_argols
argon65520593_argon_
argots74116023_argots
arsons63917213_arsons
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
baboons113211073baboons
bacons104917583ba_cons
baggers113915693baggers
baggies113814853baggies
bagging123316983bagging
baggings13307523baggings
ballons93916963ballons
barons85025383ba_rons
baryons121010473baryons
basions94213953basions
batons85519423ba_tons
biggins113410693biggins
camions113916133camions
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capons104119503ca_pons
carbons115418943carbons
cardons104519933cardons
cargoes104415223cargoes
cargos94619183cargo_s
cartons94122473cartons
cations94524143cations
cogons96818113_cogons
dacrons103211033dacrons
daemons10269233daemons
daggas937973dagg_as
daggers103714913daggers
daggles103611913daggles
dagoes85714603da_goes
dagos76419443da_go_s
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damsons1038013damsons
doggone1035683doggone
doggones1135713doggones
dragons938383dragons
dragoons1045013dragoons
epigons1048183epigons
fagging133714763fagging
faggot1139043faggo_t
faggoty1542853faggoty
fagins10513863fa_gins
fagots1039963fa_gots
falcons1239123falcons
fanions103713073fanions
fanons96115213fa_nons
flagons1137973flagons
gabions102410053gabions
gaboons10289893gaboons
gaggers103413663gaggers
gagging93013523gagging
gaggles103512593gaggles
gallons83015953gallons
gammons1237973gammons
garcons102411643garcons
garrons82713463garrons
gascons10289103gascons
goons65326773__goons
gorgons938853gorgons
hadrons113314303hadrons
hagdon1188283hagdon_
hagging133114683hagging
haggis11209513hagg_is
haggles123312483haggles
halons95720713ha_lons
isogons8217613isogons
jaggers164012893jaggers
jaggies163311083jaggies
jagging173311993jagging
jaggs148111493jagg__s
jargon1448823jargon_
jargony1834493jargony
jargoons1644663jargoons
kaons95014853ka__ons
kations114013663kations
ladrons83813193ladrons
lagans75717783la_gans
laggers94216243laggers
lagging103316733lagging
laggings11298403laggings
lagoon7410483lagoon_
lardons83914493lardons
largos74815063largo_s
leggins9259473leggins
legions84611783legions
logions86211293logions
logons79818173_logons
macons104017243ma_cons
macrons113514893macrons
maggot10311703maggo_t
maggoty1444003maggoty
magians10310753magians
magots9312363ma_gots
mammons1048513mammons
mangoes104316133mangoes
mangos94319333mango_s
margins103815193margins
maroons92615553maroons
marrons93216973marrons
mascons113411583mascons
masons83916513ma_sons
matrons93517633matrons
mignons1037863mignons
muggins11248073muggins
naggers93812653naggers
nagging102613043nagging
nasions73112383nasions
nations74720563nations
natrons73215663natrons
noggins9288453noggins
paeons83915523pa_eons
pagans95717923pa_gans
pagods105310193pa_gods
pangens103112063pangens
paragons11311503paragons
pardons103817623pardons
pargos95719043pargo_s
parsons93516873parsons
partons94620513partons
patrons93818103patrons
pigeons1039183pigeons
piggins113010473piggins
racons84319343ra_cons
racoons93912433racoons
radons74118533ra_dons
raggees93710913raggees
raggies93214733raggies
ragging103516683ragging
raggles93813283raggles
raggs75216473ragg__s
raglans82410133raglans
ragtops1035453ragtops
ramsons939563ramsons
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
rayons94113343ra_yons
regions83613473regions
saggars93610683saggars
saggers94017083saggers
sagging103116103sagging
sagos66123873sa_go_s
salmons93713263salmons
salons63823693sa_lons
saloons74415313saloons
sargos74318273sargo_s
swaggers13407223swaggers
swaggies13136693swaggies
swagging14328093swagging
taggant9310213taggant
taggants1044923taggants
taggers93514193taggers
tagging103014913tagging
talions7314103talions
talons64019433ta_lons
tampons112711553tampons
tangos74216303tango_s
tarpons92612203tarpons
tauons63412673ta_uons
taxons134211503ta_xons
tiglons837343tiglons
tigons74112263_tigons
trigons84312093trigons
trogons83410723trogons
wackos155210993wacko_s
wadmols1333913wadmols
wagers105122203wa_gers
wages95330933wa_g_es
wagged124616123wagg_ed
wagger113616013wagg_er
waggery15276903waggery
waggish15207073waggish
waggle113612303wagg_le
waggled13389363waggled
waggling14197063waggling
waggly14347293wagg_ly
waggoning1543593waggoning
waging114318383wa_ging
wagoned1256223wa_goned
wagoner1136093wa_goner
wagoners1235473wa_goners
wags86140553wa_g__s
wagsome1345213wagsome
wahoos122310593wa_hoos
wains86930863wa__ins
waitrons1136633waitrons
wakens135012043wa_kens
wallops123410413wallops
wallows133613533wallows
wangan10311223wangan_
wangles113416933wangles
wangun1037103wangun_
wanigans1244743wanigans
wanion93213063wanion_
wans76452263wa___ns
wanton94413813wanton_
wardens113711903wardens
warisons1136903warisons
warns87231003wa__rns
warrens103810893warrens
waughts14355963waughts
waygoing1633273waygoing
waygoings1742203waygoings
wazoos18288553wa_zoos
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
widgeons1343853widgeons
wigans104511703w_igans
wigeon1037223wigeon_
wigging133413833wigging
wiggings14316173wiggings
wiggles123312463wiggles
wons74942043w___ons
wontons103310533wontons
yapons114411773ya_pons
yaupons12345683yaupons
zagging193210453zagging

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.1531167915.0
2DLD Change Limit1340272676.78319759.3
3Display Results2672670.0932871.0
 (SQL Overall)1786912677.02925422.0
 
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.