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

183 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
ramrods103658(None) 
ramrod936831ramrod_
nimrods1044282nimrods
ramous8417112ram_ous
ramsons939562ramsons
sarods74918572sa_rods
tramroads1243002tramroads
across8312643_across
allods73615083_allods
ambos95321253_ambo_s
ambroids1346513_ambroids
amends94713283_amends
amids85627523_am_ids
ammos94815823_ammo_s
amoks11413553_am_oks
amorous9311133_amorous
apods86316343_a_pods
aprons8316993_aprons
aramids102810513aram_ids
armloads1144233armloads
armors85017813arm_ors
aroids75118223_a_roids
arrows92813493_arrows
aurous64119263_aurous
bamboos1348753bamboos
bards87139643ba_r_ds
barons85025383ba_rons
barrows123411693barrows
cairds96411513cair_ds
cameos105818003cameo_s
camions113916133camions
camos95927613cam_o_s
campos125217953campo_s
cards85137933ca_r_ds
carobs104818103ca_robs
carols85124983ca_rols
caroms105619573ca_roms
carroms11512403carroms
carrots9714623carrots
cramboes1436543cramboes
crambos1336783crambo_s
crampons1436643crampons
dacrons103211033dacrons
damsons1038013damsons
emerods10137653emerods
famous11412393fam_ous
fantods11177623fantods
farads104713273fa_rads
fards96629843fa_r_ds
faros85532023fa_ro_s
farrows13259793farrows
gambols1238593gambols
gammons1237973gammons
garrons82713463garrons
hadrons113314303hadrons
hagrode1236453hagrode
hairdos1136823hairdos
hards96435653ha_r_ds
harrows132611043harrows
hatreds11307813hatreds
hotrods1148283hotrods
karoos102415813ka_roos
kaross101910023ka_ross
karroos1139313karroos
labroids1155843labroids
ladrons83813193ladrons
lairds74711613lair_ds
lameds94812033lam_eds
lampads12477623lampads
lards65331863la_r_ds
macrons113514893macrons
macros104017013macro_s
mamboes135011823mamboes
mambos125414493mambo_s
mammons1048513mammons
marmots11311513marmots
marrons93216973marrons
marrows122911833marrows
matrons93517633matrons
mods77945063__m_ods
moods85224623__moods
nards65928463na_r_ds
narrows10258853narrows
natrons73215663natrons
nimrod934873nimrod_
pagods105310193pa_gods
pards85634333pa_r_ds
parodos103011753pa_rodos
parody12410093pa_rody
parols84722613pa_rols
parous84024163pa_rous
parrots9312743parrots
patrols93513513patrols
patrons93818103patrons
prods85523553__prods
racons84319343ra_cons
racoons93912433racoons
radios74018673radio_s
radons74118533ra_dons
rads56046613ra___ds
ragtops1035453ragtops
raids65827523ra__ids
railroads1043523railroads
ramada9310183ram_ada
ramadas1039303ramadas
ramblas112710263ramblas
rambles113118313rambles
ramees84620893ram_ees
ramets83517393ram_ets
ramies84630463ram_ies
ramjets1635163ramjets
rammed113117303rammed_
rammers113715043rammers
ramona8412413ram_ona
ramonas9311093ramonas
ramose8314403ram_ose
ramped114617903ramped_
rampions12248023rampions
rampole1139693rampole
rampoles1238893rampoles
ramps96224633ram__ps
ramrodded1441513ramrodded
rams65950773ram___s
ramson8310463ramso_n
ramtils938413ramtils
ramulous1045883ramulous
ramus76418283ram__us
rancors9811373rancors
randoms102112433randoms
rands65930453ra__nds
ranids75118703ra_nids
ransoms92410163ransoms
rapids94913893ra_pids
raptors94213353raptors
rared65738323ra_red_
rares55247443ra_r_es
rations74123433rations
ratios64922673ratio_s
ratoons73815473ratoons
ratos55528773ra_to_s
rattons73815323rattons
raucous938303raucous
rayons94113343ra_yons
razors154711663ra_zors
records105213923records
recross989843recross
regrows11269153regrows
remands104914883remands
remends105013033remends
reminds104614793reminds
remolds10299703remolds
remoras9314073remoras
repros84216003repro_s
resods74116303r_esods
retros63820193retro_s
rewords115413983rewords
rimous8311913rim_ous
rimrock1544383rimrock
rimrocks1644043rimrocks
rods56442073___rods
romeos84013173romeo_s
roods65125283r__oods
rumors81110403rum_ors
safrols1036863safrols
sambos104315193sambo_s
sards64736183sa_r_ds
sarod65325873sa_rod_
sarode75317513sa_rode
sarodes84216143sa_rodes
saros55238063sa_ro_s
schrods1337433schrods
scrods94111613_scrods
tampons112711563tampons
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_ro_s
tarots66422993ta_rots
tomcods1234873tomcods
tramroad1143763tramroad
wards97734403wa_r_ds
yairds10448023yair_ds
yards95324613ya_r_ds
yarrows13277863yarrows

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.403443402.0
2DLD Change Limit1340271836.54620474.6
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.01225483.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.