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

414 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
ratoons7381547(None) 
racoons93912431racoons
rations74123431rations
ratoon64417371ratoon_
rattons73815321rattons
rattoons8327511rattoons
baboons113211082baboons
batons85519422bat_ons
bradoons1136762bradoons
cartoons104012802cartoons
cations94524142cations
cratons94316032crat_ons
dahoons1137752dahoons
dragoons1045012dragoons
gaboons10289902gaboons
kations114013662kations
lagoons839252lagoons
maroons92615552maroons
matrons93517632matrons
matzoons19105082matzoons
nations74720562nations
natrons73215662natrons
orations81515802orations
patrons93818102patrons
patroons102710602patroons
platoons1038682platoons
raccoons1265452raccoons
racons84319342ra_cons
racoon83814472racoon_
radons74118532ra_dons
ramsons939562ramsons
ratans63819372rat_ans
ration64226012ration_
ratios64922672ratio_s
ratlins73615582ratlins
ratooned977102ratooned
ratooner887002ratooner
ratooners965832ratooners
ratos55528762rat_o_s
rattans73411952rattans
rattens74213402rattens
ratton64116122ratton_
rattoon7359242rattoon_
rayons94113342ra_yons
retools73411022retools
saloons74415322saloons
toons55027532__toons
aboon74918703_aboon_
acorns85013013_acorns
actions94218513actions
adorns74212613_adorns
aeons57624653_a_eons
aerations9317903aerations
agons66423783_a_gons
alations82518893alations
aloins65022203_aloins
anions64123033_anions
anyons94513503_anyons
aprons8316993_aprons
archons12311583archons
argons75018203_argons
arsons63917213_arsons
atmans84413963_atmans
atolls65511353_atolls
atoms76817563_at_oms
atone56527983_at_one
atones65225773_atones
atony87218853_at_ony
attorns738443attorns
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
babools11319453babools
baboon103613913baboon_
baboos103517013baboo_s
bacons104917583ba_cons
ballons93916963ballons
balloons103110523balloons
barons85025383ba_rons
baryons121010473baryons
basions94213953basions
bassoons1036553bassoons
bastions10411693bastions
batboys1465833batboys
bathos116215633batho_s
baton75822423bat_on_
battens95313263battens
bazooms20285383bazooms
bazoos173212623bazoo_s
betons84919553bet_ons
boons75031913__boons
bradoon1037353bradoon_
bridoons1145423bridoons
buttons9310333buttons
cahoots1238473cahoots
camions113916133camions
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capons104119503ca_pons
captions123813223captions
carbons115418943carbons
cardons104519943cardons
cardoons113411943cardoons
cartons94122473cartons
cartoon94114463cartoon_
cartoony13377403cartoony
cation83925503cation_
catkins133012563catkins
catlins93818843catlins
cautions103313183cautions
citrons92913223citrons
cocoons11310563cocoons
coons76737283__coons
cottons9312193cottons
crampons1436643crampons
crampoons1544063crampoons
craton84517193crat_on_
crayons12439233cra_yons
creations112614543creations
croons85418423_croons
crotons93714373crot_ons
cytons111710183cyt_ons
dacrons103211033dacrons
daemons10269233daemons
dahoon1039053dahoon_
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damsons1038013damsons
datos65222783dat_o_s
dattos74311903datto_s
diatrons939613diatrons
dragons938383dra_gons
dragoon935283dragoon_
durations10311463durations
eftsoons1142613eftsoons
elations83719123elations
enations83316903enations
erasions8310983erasions
etalons739073etalons
factions133013063factions
falcons1239123falcons
fanions103713073fanions
fanons96115213fa_nons
fathoms1537523fathoms
fatsoes10379423fatsoes
fatsos9389423fatso_s
fattens105111713fattens
fatuous1037783fatuous
fatwoods1585953fatwoods
festoons1136443festoons
fractions1449103fractions
futons93911513fut_ons
gabions102410053gabions
gaboon93211773gaboon_
gadroons1037013gadroons
gallons83015953gallons
galloons9289703galloons
galoots82410793galoots
gammons1237973gammons
garcons102411643garcons
garrons82713463garrons
gascons10289103gascons
gators74115843gat_ors
gazoos163010223gazoo_s
goons65326773__goons
gratins84119183grat_ins
gyrations1336923gyrations
haboobs1495463haboobs
hadrons113314303hadrons
hagdons1258523hagdons
halons95720713ha_lons
harpoons1337483harpoons
hatpins123410643hatpins
introns73515023introns
jargons1558203jargons
jargoons1644663jargoons
jatos125116823jat_o_s
jetons134512613jet_ons
jettons1437273jettons
kaons95014853ka__ons
karoos102415803karoo_s
kation104315683kation_
kazoos19259113kazoo_s
kroons103711243_kroons
ladrons83813193ladrons
lagoon7410483lagoon_
lampoons12266873lampoons
lardons83914493lardons
lardoons9398483lardoons
lateens74210553lateens
latens64620213lat_ens
latinos73613803latinos
latosols845003latosols
lattens75014673lattens
lattins74115483lattins
loons55731723__loons
lotions74614763lotions
macons104017243ma_cons
macrons113514893macrons
madzoons20124773madzoons
mammons1048513mammons
marathons1446423marathons
maroon83118203maroon_
marrons93216973marrons
mascons113411583mascons
masons83916513ma_sons
mastodons1244123mastodons
matins84527783mat_ins
matron83918313matron_
mattins93316143mattins
matzohs2134373matzohs
matzoon1896473matzoon_
matzos1749263matzo_s
metopons12107023metopons
moons75331003__moons
motions94215003motions
mutons84314363mut_ons
muttons949283muttons
nasions73112383nasions
nation64322803nation_
natron64116023natron_
nitons64614903nit_ons
noons54125283__noons
notions74014483notions
options93810603options
oration71617713oration_
orators7313823orat_ors
ovations11149263ovations
pactions122613503pactions
paeons83915523pa_eons
pardons103817623pardons
parsons93516873parsons
partons94620513partons
patens84820863pat_ens
pathos115516693patho_s
patins87528783pat_ins
patios85221783patio_s
patois84319363pat_ois
patrols93513513patrols
patron84018043patron_
patroon92811973patroon_
pattens95414923pattens
photons123814433photons
pitons85319043pit_ons
platoon938953platoon_
pontoons10279313pontoons
poons75430973__poons
potions93417423potions
protons93118003prot_ons
putons83515153put_ons
pythons1537363pythons
rabbins112811343rabbins
rabboni1144803rabboni
rabbonis1245013rabbonis
raccoon1176163raccoon_
racon75422143ra_con_
radians83013823radians
radios74018673radio_s
radomes10311053radomes
radon64620503ra_don_
raglans82410133raglans
ragouts838543ragouts
ragtops1035453ragtops
rains55140233ra__ins
raisins72715343raisins
ramona8412413ra_mona
ramonas9311093ramonas
ramous8417113ra_mous
rampions12248023rampions
ramrods1036583ramrods
ramson8310463ramson_
rancors9811373rancors
randans8313213randans
randoms102112433randoms
ransoms92410163ransoms
raptors94213353raptors
ratals64219583rat_als
ratan53722663rat_an_
ratany93411873rat_any
ratbags1035763ratbags
ratches123620463ratches
ratels64518213rat_els
raters63936583rat_ers
rates55352013rat__es
ratfink1434943ratfink
ratfinks1542853ratfinks
rathole10312053rathole
ratholes11312413ratholes
ratine65131823rat_ine
ratines75328583ratines
rating74938703rat_ing
ratings84217413ratings
ratio55227583ratio__
rational8412543rational
rationals949943rationals
rationed9410093rationed
ratites74920683ratites
ratlin64116523ratlin_
ratline74517803ratline
ratlines83815293ratlines
rato45436973rat_o__
ratooning1037173ratooning
rats46260373rat___s
rattan63613603rattan_
ratteens8256053ratteens
ratten64217383ratten_
ratters74422473ratters
ratting83822363ratting
rattles73217303rattles
rattooned1043843rattooned
raucous938303raucous
ravens93916883ra_vens
ravins94622563ra_vins
rawins95617623ra_wins
rayon83815703ra_yon_
razors154711663ra_zors
reactions11711713reactions
readorns938283readorns
reasons72514943reasons
rebooks134010513rebooks
reboots93512093reboots
reckons13269653reckons
recoins94019243recoins
recons84922993r_econs
recooks134711233recooks
redons75222183r_edons
regions83613473regions
rejoins143111383rejoins
relations92418333relations
reloans7313133reloans
relooks114010723relooks
renowns10277833renowns
reroofs1037943reroofs
retains74522253retains
retook104313443retoo_k
retool63914483retoo_l
retorn610923433retorn_
retorts76016513retorts
retros63820193retro_s
returns79712593returns
rhytons13295883rhytons
ribbons1136253ribbons
rigadoons1142633rigadoons
riotous739863riotous
roans54926443r__oans
rockoons1445003rockoons
rogations101510823rogations
ronions73313343ronions
ronyons10258433ronyons
roods65125283r__oods
roofs85321153r__oofs
rooks95325043r__ooks
rooms75324683r__ooms
roots55933673r__oots
rotations91613843rotations
rotors64917953rot_ors
rotos56027883rot_o_s
ructions102811683ructions
rutins63818393rut_ins
salmons93713263salmons
salons63823693sa_lons
saloon64418023saloon_
saloops93510133saloops
santoors837633santoors
sateens73710753sateens
satins64930483sat_ins
satoris7317253satoris
setons64620173set_ons
simoons937943simoons
spoons84116023_spoons
stations82415223stations
stolons73410243_stolons
stooks105115373_stooks
stools65117023_stools
stoops85917893_stoops
swoons94511143_swoons
taboos83815433taboo_s
tactions102912423tactions
talions7314113talions
talons64019443ta_lons
tampons112711563tampons
tarpons92612213tarpons
tatsois748373tatsois
tattoos738643tattoos
tauons63412673ta_uons
taxons134211503ta_xons
testoons837323testoons
tons46553053__t_ons
tools55325243__tools
toon47740633__toon_
toots55331873__toots
towns86018883__towns
toyons95512133__toyons
tractions11511623tractions
tritons73814883trit_ons
tycoons1235173tycoons
uptowns12194343uptowns
varooms1248883varooms
waggons1235503waggons
wagons103911213wa_gons
wahoos122310593wahoo_s
waitrons1136633waitrons
wanions104011373wanions
wantons103713013wantons
wazoos18288553wazoo_s
yahoos12209243yahoo_s
yapons114411773ya_pons
yaupons12345683yaupons
zoons144919693__zoons

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.393454684.5
2DLD Change Limit1340274147.18618651.1
3Display Results4144140.1562653.8
 (SQL Overall)1786914147.73523101.6
 
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.