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

455 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
ramjet1531154(None) 
ramet75743141ram_et
ramjets1635161ramjets
armet76739452arm_et
armlet84118192armlet
camlet104426582camlet
fanjet16311392fanjet
hamlet113722792hamlet
mammet94319252mammet
rabbet103818652rabbet
rachet115028972rachet
racket125229422racket
rajes125022782ra_jes
ramate83921692ramate
ramee74633852ram_ee
ramees84620892ramees
ramen75625192ram_en
ramets83517392ram_ets
ramie75027822ramie_
ramies84630462ramies
rammed113117302rammed
rammer103519652rammer
ramped114617902ramped
remeet86325472remeet
remet74843722rem_et
samlet84126562samlet
scramjet1945032scramjet
abet610547943_a_bet
abject17137703_abject
aglet65534143_aglet
ajee115928233_a_jee
amber94523213_amber
ambit94223713_ambit
ameer75618983_ameer
amen66733153_am_en
ament76036543_ament
amie66339853_amie_
amies76837693_amies
amort75832203_amort
amped104820513_amped
amulet8419573_amulet
arame75026623aram_e_
arames84622573aram_es
armed86324433arm_ed
armer76924443arm_er
armets84918353arm_ets
armies85123693armies
armlets94610063armlets
armpit10811093armpit
armrest9310163armrest
asset55932263_asset
baguet9316103baguet
ballet84733973ballet
bammed133913243bammed
bannet84925333bannet
barbet104427883barbet
barret84930483barret
basket125722913basket
basset85225383basset
brachet144020313brachet
bracket154117233bracket
cablet104429463cablet
cachet134526413cachet
cadet85339343ca_det
callet84536763callet
camber124418483camber
came87648753cam_e_
camel96822803cam_el
cameo95924993cam_eo
cames97047313cam_es
camlets114314623camlets
camped134720233camped
camper124722213camper
caplet104226813caplet
caret75360563ca_ret
carnet84732873carnet
carpet104530093carpet
casket124820993casket
comet95946073com_et
crambe1239073crambe_
crambes1339963crambes
crammed143710123crammed
crammer134010963crammer
cramped144712183cramped
crampit1338863crampit
crumpet133711063crumpet
dame77140313dam_e_
dames85435853dam_es
dammed124214793dammed
dammer114317933dammer
dammit11311133dammit
damned104212913damned
damner95213433damner
damped124315583damped
dampen114310593dampen
damper114117753damper
dampest12411043dampest
damsel9148033damsel
drabbet12319573drabbet
dragnet91211433dragnet
drammed13378073drammed
eaglet73722583eaglet
emmet94221383_emmet
facet106038523fa_cet
fame95639393fam_e_
famed115928343fam_ed
fames105735923fam_es
fanjets1734803fanjets
faucet115816553faucet
frame105821803fram_e_
framed125116523fram_ed
framer114817443fram_er
frames115119863fram_es
fumet105630223fum_et
gadget93616183gadget
gadje1457743gadje_
gallet73630853gallet
gambe106219213gambe_
gambes116318313gambes
gambit114714213gambit
game76644323gam_e_
gamed95126393gam_ed
gamer84928943gam_er
games86238553gam_es
gamest94919933gamest
gamete9313593gam_ete
gamey115320553gam_ey
gamier93617933gamier
gamiest102816233gamiest
gammed124216163gammed
gammer1112318333gammer
gamut8322983gam_ut
gannet74321853gannet
garget84327273garget
garnet73928413garnet
garret74426553garret
gasket114417253gasket
gimlet93716663gimlet
gramme114210333gramme_
grammes123611323grammes
grommet12268453grommet
grummet12298873grummet
hadjee174111823hadjee
hadjes175210403hadjes
haet75659503ha__et
haffet15311703haffet
hajes155420943ha_jes
hajjes15485243hajjes
hamate113319833hamate
hame97043133ham_e_
hames106138703ham_es
hamlets123211403hamlets
hammed144116973hammed
hammer138120033hammer
hamper134518653hamper
haslet93222713haslet
imaret81121233imaret
inkjet1737453inkjet
jacket194720673jacket
jambe165314753jambe_
jambed184811403jambed
jambes175914053jambes
jammed183811503jammed
jammer174014133jammer
jet106754823___jet
kame105728233kam_e_
kames115024693kam_es
labret8320223labret
lambed115614783lambed
lambent113711303lambent
lamber104418493lamber
lambert113617113lambert
lame66849293lam_e_
lamed85235293lam_ed
lament85024943lament
lamer75233703lam_er
lames75445543lam_es
lamest84722763lamest
lammed113915623lammed
lamped114017543lamped
lancet84223573lancet
lappet103817733lappet
limpet103518633limpet
magnet9320663magnet
mallet84433053mallet
mamey125418833mam_ey
mamie95826003mamie_
mamies104626243mamies
mammee94417853mammee
mammer94218863mammer
mammets103911113mammets
mammey124310893mammey
mamzer19459833mamzer
market123226043market
maumet103518883maumet
meet65350553__meet
met56072433__m_et
name65637413nam_e_
named85223063nam_ed
namer75622103nam_er
names74833363nam_es
objet141213143_objet
packet144726503packet
palet74650803pa_let
pallet84232653pallet
pamper124316663pamper
parget94529393parget
premeet11615153premeet
projet15315183projet
propjet1839913propjet
rabat72832223ra_bat
rabbets11279423rabbets
rabbit102914563rabbit
rabies85226023rabies
race66746263ra_ce_
raced87635313ra_ced
racer75233023ra_cer
races74943243ra_ces
rachets124516833rachets
racier85120973racier
raciest92820013raciest
racist82822793racist
racked134526083racked
racker124824553racker
rackets134916873rackets
rackety16499113rackety
racquet1838743racquet
radded94716493radded
raft76245913ra__ft
rafted104714703rafted
rafter94517583rafter
rage55742353ra_ge_
raged74829453ra_ged
ragee65432663ra_gee
ragees74618663ragees
rages64539443ra_ges
ragged94620263ragged
raggee84217603raggee
ragmen93712183ragmen
ragout7317183ragout
raided85017703raided
raider74318743raider
railed74727543railed
railer64524933railer
raiment9315413raiment
rained75024603rained
raise54828053raise_
raised76120333raised
raiser66620103raiser
raises64826543raises
raj105740223ra_j__
raja117918683ra_j_a
rajah155711423ra_jah
rajas127317723ra_jas
rake84841573ra_ke_
raked105831423ra_ked
rakee96031173ra_kee
rakees104516973rakees
raker94529793ra_ker
rakes94440353ra_kes
rale45050563ra_le_
rales54947493ra_les
ram56867273ram___
ramada9310183ramada
ramal74622243ram_al
rambla103510933rambla
ramble104519973ramble
rambled123913523rambled
rambler113313263rambler
rambles113118313rambles
ramenta9311183ramenta
rami66034093ram__i
ramify14268753ramify
rammers113715043rammers
rammier112811023rammier
rammiest12299933rammiest
rammy124312493ram_my
ramona8412413ramona
ramose8314403ramose
ramous8417113ramous
ramp85934003ram__p
rampant11312173rampant
rampart11311993rampart
ramps96224633ram_ps
ramrod936833ramrod
rams65950773ram__s
ramson8310463ramson
ramtil8311033ramtil
ramus76418283ram_us
rance75028513rance_
rances84625443rances
ranee55438103ra_nee
ranees64623963ranees
range64728413range_
ranged84824313ranged
ranger73925523ranger
ranges73826923ranges
ranked114620743ranked
ranker105021903ranker
rankest112713813rankest
rant45864683ra__nt
ranted74324703ranted
ranter63826823ranter
rape65041633ra_pe_
raped85334623ra_ped
raper74932753ra_per
rapes75740723ra_pes
raphe104916423raphe_
raphes115117453raphes
rapier84019993rapier
rapist82520673rapist
rapped114122683rapped
rappee103618673rappee
rappel104211953rappel
rappen103512713rappen
rapper104621573rapper
rapt67245313ra__pt
rare45348433ra_re_
rared65738323ra_red
rarer54731703ra_rer
rares55247443ra_res
rarest65725483rarest
rase46149983ra_se_
rased65033933ra_sed
raser55633413ra_ser
rases55447213ra_ses
rasher95024123rasher
rashes95330153rashes
rashest103916873rashest
rasped94715203rasped
rasper83917333rasper
raster64731443raster
rat37892743ra___t
ratchet124218333ratchet
rate45458763ra_te_
rated65441383ra_ted
ratel54224883ra_tel
rater54943283ra_ter
rates55352013ra_tes
rathe85821923rathe_
rather94319743rather
ratite65022423ratite
ratted74923343ratted
ratten64217383ratten
ratter64326313ratter
rave75542093ra_ve_
raved94931433ra_ved
ravel84621513ra_vel
raven84723443ra_ven
raver85631493ra_ver
raves85441973ra_ves
rawer84623733ra_wer
rawest93615063rawest
raxed135622663ra_xed
raxes124729393ra_xes
rayed95127503ra_yed
raze135235433ra_ze_
razed155027983ra_zed
razee145827803ra_zee
razeed163710013razeed
razees154314763razees
razer144824273ra_zer
razes145032703ra_zes
razzed15478283razzed
razzes144910073razzes
reamed94326123ream_ed
reamer84325213ream_er
reeject16349623reeject
reflet94024233reflet
reglet73724233reglet
regret73723533regret
reject154116283r_eject
relet54749823r_elet
remate84428683remate
remeets93712413remeets
remelt85123123remelt
remex146315793rem_ex
remint85329983remint
remit75737223rem_it
remixt155014853remixt
remote84222603remote
rennet64624853rennet
reset55051863r_eset
resojet14312823resojet
ret35982833r___et
revet84938843r_evet
rewet85135153r_ewet
riblet84222443riblet
rillet64828853rillet
rime65138883rim_e_
rimed84826373rim_ed
rimer75429243rim_er
rimes75634543rim_es
rimier83916273rimier
rimiest93215853rimiest
rimmed114812303rimmed
rimmer103516033rimmer
rivet85636363r_ivet
roamed95215093roam_ed
roamer84715163roam_er
rochet115423003rochet
rocket125425283rocket
romeo73719703rom_eo
romped114513653romped
romper104213683romper
roquet154415893roquet
roset55945243r_oset
roupet84218343roupet
rumen74419503rum_en
rummer104715483rummer
rummest11279833rummest
runlet63821413runlet
russet6319433russet
sachet114725773sachet
sallet63734543sallet
same65245643sam_e_
samek114915273sam_ek
samiel8313333samiel
samite83020603samite
samlets93813553samlets
scramjets2052063scramjets
tablet84227643tablet
tacet75840023ta_cet
tacket124627493tacket
tajes124920693ta_jes
tame66343663tam_e_
tamed85528513tam_ed
tamer75230103tam_er
tames75242013tam_es
tamest85721293tamest
tamped114317043tamped
tamper104618513tamper
tappet103820113tappet
target75028903target
tasset65925313tasset
traject1637043tra_ject
tramel84113713tram_el
trammed123810713trammed
trammel11357663trammel
tramped124312433tramped
tramper113812163tramper
trijet133916553trijet
trumpet113810723trumpet
unmeet83815743unmeet
unmet74426393unm_et
valet84337873va_let
vamped144211013vamped
vamper134212653vamper
varlet9423503varlet
wadset10314303wadset
wallet93327093wallet
wame95035483wam_e_
wames106432803wam_es
yamen104115183yam_en
yammer133713183yammer

Search took 7 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.376475242.0
2DLD Change Limit1127164555.61020092.0
3Display Results4554550.1403250.0
 (SQL Overall)1786914556.12629169.3
 
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.