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

486 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
steamy11511237(None) 
seamy105921271s_eamy
steady103510201steady
steam76322931steam_
steams84916901steams
stemmy13417031stemmy
streamy12509481streamy
beamy126218572_beamy
creamy134811362creamy
dreamy12509992dreamy
gleamy12398112gleamy
seam66645972s_eam_
seams75731662s_eams
sleazy18267392sleazy
smeary114110802smeary
sneaky13427842sneaky
stagy96618892st_agy
stamp95217362st_amp
stay78333722st_a_y
stead65520272stea_d
steads74116222steads
steak95219802stea_k
steaks104415852steaks
steal56125472stea_l
steals64020062steals
steamed103712142steamed
steamer93313092steamer
steamily1335802steamily
steely93612572steely
stem610628252ste_m_
stemma10328132stemma
stems75219952ste_ms
stewy116112062ste_wy
stey76224412ste__y
stimy105114742st_imy
stormy115510732stormy
strawy1210312822strawy
stray88525572stra_y
streaky14447812streaky
stream84717292stream_
streams94713372streams
stymy13358292st_ymy
swamy136714402s_wamy
sweaty123710052sweaty
team66238652_team_
teams75726512_teams
teary85124052_teary
abeam9316533abeam_
astray95615543astra_y
ataxy1537313at_axy
atomy107415193at_omy
aweary1237303aweary
beady114719923_beady
beaky146118023_beaky
beam86939233_beam_
beams95328173_beams
bigamy1436343bigamy
bleary115112553bleary
bready124511183bready
bream95121813bream_
breams104815043breams
creaky154911553creaky
cream95721353cream_
creams104715253creams
creasy114612303creasy
deary95826843_deary
demy105422853_de_my
digamy1335893digamy
dream85120393dream_
dreams94513983dreams
dreamt94615713dreamt
dreary104611673dreary
easy76224493__easy
elmy95616793__elmy
emmy116013243__emmy
enemy1059993ene_my
esteem838813esteem_
esteems935243esteems
estray95713333estra_y
estuary1034683estuary
flamy135217473_flamy
fleam106017283fleam_
fleams115011943fleams
foamy135313203_foamy
freaky16439233freaky
gamy105427533__gamy
gemmy135211053_gemmy
germy115113663_germy
gleam86916733gleam_
gleams94812253gleams
greasy10419463greasy
gremmy1454473gremmy
heady125117263_heady
heapy135914983_heapy
heavy144814183_heavy
infamy1435653infamy
isogamy1343993isogamy
item65620383ite_m_
items7499613ite_ms
jemmy19498553_jemmy
leady95618603_leady
leafy116316213_leafy
leaky125217723_leaky
leary85927383_leary
leavy115715773_leavy
loamy105913343_loamy
mealy104422183_mealy
meany104620483_meany
meaty107021313_meaty
oogamy1235633oogamy
osteal6312963ostea_l
osteoma945433osteoma
ostiary1036463ostiary
ostomy1137833ost_omy
peaky145718153_peaky
peaty105725693_peaty
peavy135014843_peavy
preamp1238993preamp
queasy1855173queasy
queazy2743573queazy
ready94821503_ready
ream65841613_ream_
reams75729623_reams
reteam83214533reteam_
reteams9339563reteams
rheumy1433353rheumy
sagy85327083s__agy
salami8313103salami
salary9515213salary
same65245643s__ame
samp85733593s__amp
satay84718463sata_y
satem76021463sate_m_
satrapy12497933satrapy
say67264763s__a_y
scaly104718723s_caly
scam85932353s_cam_
scamp115717313s_camp
scams94423973s_cams
scary105222593s_cary
scram910621623scram_
scrams105216623scrams
screaky16436223screaky
scream104814253scream_
screams114810623screams
scummy15265223scummy
sea36161293s_ea__
seal45654373s_ea_l
seals54839693s_eals
seaman84015903s_eaman
seamed94823883s_eamed
seamen84518563s_eamen
seamer84223613s_eamer
sear47353843s_ea_r
sears54744913s_ears
seas45755273s_ea_s
seat47575563s_ea_t
seats54844343s_eats
seaway12309993s_eaway
sedgy104512793s_edgy
seedy94821533s_eedy
seely84522633s_eely
seem65438563s_eem_
seemly1138433seemly
seems75525023s_eems
seepy104717973s_eepy
seme65836653s_e_me
semi65127223s_e_mi
senary93716073senary
sepoy10314303s_epoy
serry84824123s_erry
sesame8311013sesame
seta45637313seta__
setae56026223seta_e
setal56430903seta_l
sexy146418023s_e_xy
shady125416513s_hady
shaky154616843s_haky
shaly114322863s_haly
sham96436363s_ham_
shame105726703s_hame
shammy16388503shammy
shamoy14379913s_hamoy
shams105829413s_hams
shay107133343s_ha_y
shea76031573shea__
sheaf115424123shea_f
sheafs124912883sheafs
sheal84927703shea_l
sheals94420643sheals
shear85424833shea_r
shears93820903shears
sheas86331793shea_s
sheath12412893sheath
sheave124514003sheave
sheeny124912193sheeny
shelly124414473shelly
shelty124011553shelty
shelvy15377863shelvy
sherry124510413sherry
shimmy16306413shimmy
shoaly124010773shoaly
skean94415623skea_n
skeane104611373skeane
skeans104512913skeans
skelm114211293skelm_
skelms12368023skelms
skerry13356103skerry
slam67737973s_lam_
slams74927903s_lams
slaty86523153s_laty
slay76436383s_la_y
sleave94714153sleave
sleaze152611863sleaze
sleazo15257523sleazo
sleeky13398963sleeky
sleepy11479413sleepy
sleety94112653sleety
slimy105417423s_limy
slummy13325863slummy
smarmy13629353smarmy
smear74416393smea_r
smears84714433smears
smegma1134113smegma
smelly114110363smelly
snaky125113913s_naky
sneak96016173snea_k
sneaks104312493sneaks
sneap75514823snea_p
sneaps84510863sneaps
sneery93610413sneery
sneezy18345273sneezy
soapy106114783s_oapy
sodomy1276673sodomy
spacy125415623s_pacy
spam85930043s_pam_
spams94922193s_pams
spay96631663s_pa_y
speak114618673spea_k
speaks125114583speaks
spean74620513spea_n
speans85417143speans
spear75821063spea_r
spears84019473spears
speedy1218410793speedy
spendy124911143spendy
sperm93216023sperm_
sperms102512603sperms
splay105816043spla_y
spray106720063spra_y
spumy124610363s_pumy
squama1736533squama
squeaky2343083squeaky
stab67329933st_a_b
stably113314123stably
stabs76221383st_abs
stack114421693st_ack
stade64825303st_ade
staff113817713st_aff
stag57332003st_a_g
stage65330193st_age
stagey105915583stagey
staggy115510393staggy
stags66226743st_ags
staid66722083st_aid
staig65519643st_aig
stain55727943st_ain
stair54719943st_air
stake95927533st_ake
stale55637103st_ale
stalk94518003st_alk
stalky13499303stalky
stall54722353st_all
stamen84115943st_amen
stamps105614023st_amps
stand65923283st_and
stane55933003st_ane
stang66424683st_ang
stank95823303st_ank
staph104314653st_aph
star48037763st_a_r
stare54440263st_are
stark95425623st_ark
starry94911673starry
stars55836573st_ars
start55642313st_art
stash84916973st_ash
stat47352693st_a_t
state56237333st_ate
stats55933363st_ats
stave85324993st_ave
staw78627693st_a_w
stays86022023st_ays
steaded92811673steaded
steadily1236213steadily
stealer72913973stealer
stealth1096453stealth
stealthy14103063stealthy
steamers103410873steamers
steamier1048303steamier
steaming114013213steaming
stearic939423stearic
stearin7312003stearin
steed66024943ste_ed
steeds73814883steeds
steek95418003ste_ek
steeks103613703steeks
steel55721993ste_el
steels64117983steels
steep76020703ste_ep
steeply1236293steeply
steeps85215193steeps
steer55423863ste_er
steers63820983steers
steeve93710903steeve
stein54620543ste_in
steins64818343steins
stela54019043ste_la
stelae63716483stelae
stelai63912563stelai
stelar64013863stelar
stele55026843ste_le
steles63725663steles
stelic8313083stelic
stella63612973stella
stemmas11256973stemmas
stemmed12278153stemmed
stemmer113210183stemmer
stemmery15334693stemmery
stench114111163stench
stenchy15256213stenchy
steno54716863ste_no
stenoky1444253stenoky
stenos63915773stenos
stent55634513ste_nt
stents65019453stents
step67126293ste__p
stepdame1343623stepdame
steppe10319873steppe
steps76619883ste_ps
stere55328543ste_re
stereo65317913stereo
steres63929533steres
steric8317063steric
stern55319123ste_rn
sterna63712763sterna
sternly1037853sternly
sterns64616763sterns
sterol6613333sterol
stet45947323ste__t
stets55423913ste_ts
stew77525463ste__w
steward1138063steward
stewed104814243stewed
stews85519143ste_ws
sticky154711343sticky
stigma9226763stigma
stilly93714093stilly
stime76521803st_ime
stingy105213203stingy
stinky134611073stinky
stithy12398213stithy
stoa45425913stoa__
stoae55024263stoa_e
stoai55417873stoa_i
stoas55126023stoa_s
stoat57135953stoa_t
stoats65117483stoats
stocky15369153stocky
stodgy11415733stodgy
stogey105811543stogey
stogy95414083st_ogy
stoma75918273st_oma
stomal85213313stomal
stomas84816323stomas
stomp95616663st_omp
stoney96217353stoney
stony85818643st_ony
storey95217613storey
storm76520403storm_
storms85814633storms
story86723033st_ory
stoury9529943stoury
strafe95215983strafe
strain64919573strain
strait64025893strait
strake104017393strake
stramony1344933stramony
strand74514823strand
strang75718313strang
strap77925263stra_p
strappy14205263strappy
straps87721783straps
strass67117223strass
strata63616283strata
strath93216373strath
strati63518903strati
straw813321293stra_w
straws98718673straws
strays96417933strays
streak104613623strea_k
streaks114411273streaks
streamed11258903streamed
streamer10239513streamer
stripy115812743stripy
stroma84313073stroma
stroy87720393st_roy
strum75619453strum_
struma84313273struma
strums84716453strums
stubby1345043stubby
studly10397693studly
study94411793st_udy
stuffy15317083stuffy
stum65526023st_um_
stump94616463st_ump
stumpy13458133stumpy
stums75320083st_ums
sturdy1037043sturdy
sty66227313st___y
sudary1038703sudary
suety85318493sue_ty
sugary1039013sugary
sunbeamy1542353sunbeamy
swam96329983s_wam_
swami105614523s_wami
swamp125015323s_wamp
swampy16437233s_wampy
sway107128233s_wa_y
swear85316853swea_r
swears94114073swears
sweat85628403swea_t
sweats94814613sweats
sweeny12358843sweeny
sweepy14447453sweepy
swimmy16234353swimmy
syngamy1643113syngamy
tam58663423_t_am_
tame66343663_t_ame
tammy124013223_tammy
tamp86133003_t_amp
tams67247933_t_ams
tea37353323_tea__
teach105221123_teach
teak85930843_tea_k
teaks94222903_teaks
teal45546503_tea_l
teals56234133_teals
teamed95418593_teamed
teapoy1138113_teapoy
tear45242883_tea_r
tears55436463_tears
teas45851493_tea_s
tease55428713_tease
teat45963633_tea_t
teats55636813_teats
techy135612013_techy
teddy10489493_teddy
teem66132603_teem_
teems76019783_teems
teeny85417883_teeny
telly84920823_telly
temp85323333_te_mp
tenty86121603_tenty
tepoy10312163_tepoy
term66233153_term_
termly1138433_termly
terms75523473_terms
terry84721873_terry
testy85419063_testy
tetany959843_tetany
thymy16437923_thymy
toady96814343_toady
tommy124712233_tommy
tram67034553_tram_
tramp96319773_tramp
trampy13499253_trampy
trams75327673_trams
tray77632593_tra_y
treaty94414353treaty
tummy124711993_tummy
tweaky1634023tweaky
uneasy9278853uneasy
unsteady1243513unsteady
vealy115817773_vealy
weary115620613_weary

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.403443402.0
2DLD Change Limit1127164866.98616134.6
3Display Results4864860.2961641.9
 (SQL Overall)1786914867.68523251.9
 
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.