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

402 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
ramson831046(None) 
damson938061damson
ramsons939561ramsons
arson55118832_arson
camion103917192camion
crampon1336942crampon
crimson1135642crimson
damsons1038012damsons
gammon1138902gammon
kamsin1238322kamsin
mammon939642mammon
mason74820182ma_son
parson83817902parson
racon75422142ra_con
racoon83814472racoon
radon64620502ra_don
raisin62716922raisin
ramen75625192ram_en
ramona8412412ram_ona
ramose8314402ramose
rampion11298582rampion
ramrod936832ramrod
rams65950772rams__
ramshorn1343922ramshorn
ransom82410942ransom
ration64226012ration
ratoon64417372ratoon
ratton64116122ratton
rayon83815702ra_yon
reason62616332reason
tampon102911232tampon
aboon74918703_aboon
aeon45634613_a_eon
agon56531883_a_gon
also46423443_also_
amain74922883_amain
amazon1736823_amazon
ambo88225133_ambo_
ambos95321243_ambos
amen66733153_am_en
amin66042243_am_in
amino75425493_amino
ammo85520133_ammo_
ammono1047373_ammono
ammos94815823_ammos
amnion84812043_amnion
amok10217403_am_ok
among85813303_am_ong
ancon75718233_ancon
anion55028813_anion
anon46134853_a_non
anyon85615223_anyon
apron7318833_apron
archon11311753archon
argon65520593_argon
arisen65316793arisen
armor75118053arm_or
arms66137493arms__
arsons63917213_arsons
avion84218343_avion
axion1211316913_axion
axon115524303_a_xon
azlon144312873_azlon
azon135725053_a_zon
baboon103613913baboon
bacon95620593ba_con
ballon84117493ballon
bamboo12310013bamboo
bams87044453bams__
baron78131243ba_ron
baryon111211613baryon
basin75026923ba_sin
basion84315853basion
basso76017283basso_
bassoon937613bassoon
bassos85313703bassos
baton75822423ba_ton
bausond1044493bausond
bison75716983_bison
bolson8410683bolson
boson76019733_boson
bradoon1037353bradoon
caisson936593caisson
cajon144513903ca_jon
cameo95924993cameo_
cameos105818003cameos
camions113916133camions
camo85731753cam_o_
camos95927613cam_os
campion133011413campion
campo115219763campo_
campong14318123campong
campos125217953campos
cams87047283cams__
cannon84514443cannon
canon74725303ca_non
canso75019403canso_
cansos84915383cansos
canton85722993canton
canyon114512033canyon
capon95221873ca_pon
carbon104919043carbon
cardon94120853cardon
carton84522663carton
cation83925503cation
chanson1238043chanson
classon937693classon
common12310803common
crambo1238043crambo_
crambos1336783crambos
crampons1436643crampons
crampoon1444543crampoon
crams96229153crams__
craton84517193cra_ton
crayon114110003cra_yon
crimsons1245633crimsons
dacron94310693dacron
daemon9279593daemon
dahoon1039053dahoon
daikon11217243daikon
daimon9259713daimon
dalton7311273dalton
daman84821163dam_an
damn75724323dam__n
dampen114310593dampen
dams77444373dams__
damsel9148033damsel
dapsone1038463dapsone
demon86520313dem_on
dobson936593dobson
dragon838843dra_gon
dragoon935283dragoon
drams86025833drams__
dramshop1692383dramshop
dromon939363drom_on
erasion7311963erasion
falcon11310293falcon
fanion94514323fanion
fanon84619013fa_non
fatso85113493fatso_
fatsos9389423fatsos
foison948933foison
frisson1045313frisson
gabion93211023gabion
gaboon93211773gaboon
gallon73715813gallon
gambeson1342693gambeson
gambol1138223gambol
gamin84422993gam_in
gammons1237973gammons
gams76648883gams__
garcon92912483garcon
garron73113493garron
gascon9339723gascon
gasman92911743gasman
gasmen93111563gasmen
gibson935123gibson
godson857383godson
grams85327313grams__
grandson1055413grandson
grison7310103grison
hadron102913753hadron
hagdon1188283hagdon
halon86124863ha_lon
hambone1439313hambone
hams96446133hams__
hansom11219153hansom
hausen9610383hausen
hyson1138693_hyson
jams135231073jams__
jargon1448823jargon
jasmin1538073jasmin
jomon14610083jom_on
kampong16294933kampong
kamseen1344013kamseen
kamsins1346963kamsins
kaon87521023ka__on
kation104315683kation
kelson1038153kelson
khamsin1643973khamsin
ladron73413323ladron
lagoon7410483lagoon
lampion11278303lampion
lampoon11267193lampoon
lams66552263lams__
lardon74415063lardon
lasso55015683lasso_
lassos64913813lassos
lemon75618183lem_on
lesson64412043lesson
liaison744473liaison
macon94519953ma_con
macron103615673macron
malison939693malison
mambo115215733mambo_
mambos125414493mambos
mammons1048513mammons
mansion9611543mansion
maroon83118203maroon
marron83717543marron
mascon103612743mascon
masons83916513ma_sons
matron83918313matron
meson74118313_meson
mon57561573__m_on
moon67140813__moon
muon65722733__muon
nasion63914083nasion
nation64322803nation
natron64116023natron
nelson638423nelson
oration71617713oration
orison6411663orison
paeon74819493pa_eon
paesan85114093paesan
paisan84417073paisan
pams85641763pams__
pardon94618733pardon
parsons93516873parsons
parton84720993parton
passion9310883passion
patron84018043patron
person83517873person
plasmon11257983plasmon
poison8312223poison
pompon1238943pompon
prams96125513prams__
prison8514023prison
psammon1342543psammon
rabbin103112293rabbin
rabboni1144803rabboni
raccoon1176163raccoon
racons84319343ra_cons
racoons93912433racoons
radian74117273radian
radio64922493radio_
radios74018673radios
radons74118523ra_dons
rads56046603rads__
raglan73711503raglan
ragman94013713ragman
ragmen93712183ragmen
rags55448373rags__
ragtop936683ragtop
rain46251733ra__in
rais45252623rais__
raise54828053rais_e
raised76120333raised
raiser66620103raiser
raises64826543raises
raising83220533raising
raisins72715343raisins
raisiny10319923raisiny
raisonne843813raisonne
ram56867273ram___
ramada9310183ramada
ramal74622243ram_al
ramate83921683ramate
rambla103510933rambla
ramble104519973ramble
ramee74633853ram_ee
ramees84620893ramees
ramekin13126493ramekin
ramet75743143ram_et
ramets83517393ramets
rami66034093ram__i
ramie75027823ram_ie
ramies84630463ramies
ramify14268753ramify
ramjet15311543ramjet
rammed113117303rammed
rammer103519653rammer
ramming123115063ramming
rammy124312493ram_my
ramonas9311093ram_onas
ramous8417103ramous
ramp85934003ram__p
rampant11312173rampant
ramped114617903ramped
ramping123316873ramping
rampions12248023rampions
rampole1139693rampole
ramps96224633ram_ps
ramrods1036583ramrods
ramshorns1442913ramshorns
ramtil8311023ramtil
ramus76418283ram_us
ran38266613ra___n
rancor8810373rancor
randan7315253randan
random92513553random
ransoms92410163ransoms
rappen103512713rappen
raps66247733raps__
raptor83912823raptor
ras37575393ra_s__
rase46149983ra_s_e
rased65033933ra_sed
raser55633413ra_ser
rases55447213ra_ses
rash76039933ra_s_h
rasing74330833ra_sing
rasp66029163ra_s_p
rasps74316663ra_sps
raspy106511703ra_spy
rassle63813203rassle
ratan53722663ra_tan
ratio55227583ratio_
rations74123433rations
ratios64922673ratios
ratlin64116523ratlin
rato45436973ra_to_
ratoons73815473ratoons
ratos55528763ra_tos
rats46260373rats__
rattan63613603rattan
ratten64217383ratten
rattons73815323rattons
rattoon7359243rattoon
raven84723443ra_ven
ravin85624653ra_vin
rawin85521473ra_win
raws75238213raws__
rayons94113343ra_yons
rays77642353rays__
razor143012603ra_zor
reams75729623reams__
reasons72514943reasons
reckon123010543reckon
recon75624243r_econ
redon65424883r_edon
region74614903region
remain85919863remain
reman75730153rem_an
rems66237723rems__
resin54131053r_esin
resod64720053r_esod
resow88217243r_esow
resown94112923r_esown
rewon86920573r_ewon
rhyton12356113rhyton
ribbon1036533ribbon
rimose8310593rimose
rims65936303rims__
rimshot1246213rimshot
risen54621883r_isen
roams74919613roams__
roman75424823rom_an
romano84912943romano
romeo73719703romeo_
romeos84013173romeos
roms67038963roms__
ronion63315643ronion
ronyon9309133ronyon
rosin55325313r_osin
rumen74419503rum_en
rumor71011323rum_or
rums64833473rums__
salmon84614183salmon
salon55228553sa_lon
saloon64418023saloon
sambo95118013sambo_
sambos104315193sambos
samisen937673samisen
samosa8510203samosa
sampan102511893sampan
samshu11134623samshu
sarsen6314233sarsen
sasin54626573sa_sin
season62714903season
simoon858063simoon
son37761953___son
stemson945163stemson
summon1037623summon
talion6317713talion
talon55824113ta_lon
tamein8313083tamein
tampan102512323tampan
tampion11298663tampion
tampons112711553tampons
tams67247933tams__
tarpon82812803tarpon
tatsoi637263tatsoi
tauon54816583ta_uon
taxon124414663ta_xon
telson6310293telson
trams75327673trams__
transom948823transom
treason748763treason
unison649033unison
vamose1159283vamose
waggon1136393waggon
wagon94312953wa_gon
wanion93213063wanion
wanton94413813wanton
warison1037083warison
weason93210823weason
yamen104115183yam_en
yams95330733yams__
yamun10419273yam_un
yapon104613583ya_pon
yaupon11345493yaupon

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 Filter1786911127160.250714764.0
2DLD Change Limit1127164027.00016102.3
3Display Results4024020.1562576.9
 (SQL Overall)1786914027.40624127.9
 
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.