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

246 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
sirupy1137705(None) 
sirup74014911sirup_
sirups83710531sirups
syrupy14285821syrupy
siruped1036012siruped
situp74414062situp_
situps8538782situps
soupy106115402s_oupy
sprucy13356322sprucy
stripy115812742stripy
syrup103010962syrup_
syrups11277952syrups
abrupt1039943abrupt
airily93014823airily
airway1237693airway
airy75734153air__y
chirpy16498913chir_py
chirrupy18132023chirrupy
circusy14374593circusy
citrusy12284183citrusy
crepy124812703_crepy
crimpy15489393crimpy
crispy13478563crispy
croupy13458733croupy
dippy135111543di_ppy
direly10311563direly
dirty95617803dir_ty
disrupt1048633disrupt
drippy14445653drippy
drupe85012993_drupe
erupt74220063_erupt
firmly1436663firmly
firry115713533fir_ry
frumpy16466883_frumpy
gimpy135212233gi_mpy
girly94415293gir_ly
grapy115416433_grapy
grippy14447763grippy
gripy115115253_gripy
grumpy14498153_grumpy
harpy136418213har_py
hippy155112793hi_ppy
irony85015903_irony
irrupt846993irrupt
jimpy195210823ji_mpy
koruny1334443koruny
lippy124511903li_ppy
mirky146315523mir_ky
miry96326753mir__y
mixup1636773mixup_
mixups1743263mixups
nippy124911113ni_ppy
occupy1543153occupy
pinup9612883pinup_
pinups1037413pinups
pipy115421513pi__py
piracy1339473piracy
ropy96323413__ropy
roupy106112713_roupy
ruby97819943__ruby
ruly76323143__ruly
sappy125413473s_appy
sarape84817573sarape
sarky125521783sar_ky
satrapy12497933satrapy
saucy104615163s_aucy
saury84317223s_aury
scaup95515993scaup_
scaups105411933scaups
scrap97120403scrap_
scrape105917573scrape
scrappy16234473scrappy
scraps106017243scraps
screwy14659463screwy
scrimpy16486133scrimpy
scrip96619193scrip_
scrips105316033scrips
script105717903script
scrub94914203scru_b
scrubby1642803scrubby
scrubs104210313scrubs
scruff1437963scruff
scruffy1842643scruffy
scrum95418203scru_m
scrums104614253scrums
scruple1137193scruple
scry96017763scr__y
scup84822383s_cup_
scups95316653s_cups
scurfy14338763scurfy
scurry11419593scurry
scurvy14386103scurvy
seepy104717973s_eepy
serape84818413serape
seraph114011163seraph
serry84824123ser_ry
serum75223473seru_m
serums83916303serums
setup73915823setup_
setups83910463setups
sharpy145211033sharpy
shirty124312563shir_ty
shlumpy1742863shlumpy
shrimpy17415403shrimpy
shrub104814893shru_b
shrubby1742363shrubby
shrubs11409213shrubs
shrug94512513shru_g
shrugs10469163shrugs
shrunk13357063shrunk
sickly153110483sickly
sieur5911893sieu_r
sieurs659043sieurs
silky125315823si_lky
silly84527623si_lly
silty84721633si_lty
simony1137903simony
simp85228773si_mp_
simply133010523simply
simps94719763si_mps
sinewy12667513sinewy
singly104015853singly
sinus55523853sinu_s
sip57656013si__p_
sipe67341043si__pe
sips65740103si__ps
sir35746673sir___
sirdar7269103sirdar
sire46150413sir__e
sired66134283sir_ed
siree55238813sir_ee
sirees64624583sirees
siren54525823sir_en
sirens65318153sirens
sires55945373sir_es
siring75128313siring
sirra54416323sir_ra
sirrah9379753sirrah
sirras63814863sirras
sirree64017343sirree
sirs44338333sir__s
sirupier1034303sirupier
siruping1136503siruping
sissy85812073si_ssy
situs55019233situ_s
sixty154912733si_xty
sizy164816393si__zy
skimpy17475723skimpy
sleepy11479413sleepy
slippy1375843slippy
slipup1034503slipup_
slipups1133193slipups
sloppy1395303sloppy
slurp74014983slurp_
slurps84410003slurps
slurry9378603slurry
smirky15406943smir_ky
snappy1366103snappy
snippy1374843snippy
snoopy11449473snoopy
snouty9419953snouty
soapy106114783s_oapy
soppy125113523s_oppy
sorely94618013sorely
sorry84618253sor_ry
sorus54527583soru_s
soup66232913s_oup_
soups75322943s_oups
sourly93612213sourly
spirula9257703spirula
spiry105017353spir__y
spray106720063spr_ay
spruce103910873spruce
sprue74717633spru_e
sprues84515763sprues
sprug85313893spru_g
sprugs94010173sprugs
sprung94610033sprung
spry96819123spr__y
spryly1435513spryly
spumy124610363s_pumy
spurry11429123spurry
spy86023743s___py
stirp76815503stir_p_
stirps85011823stir_ps
stirrup943003stirrup_
stirrups1042603stirrups
stoup75517073stoup_
stoups85313273stoups
stoury9529943stoury
strap77925263strap_
strappy14205263strappy
straps87721783straps
strawy1210312823strawy
stray88525573str_ay
strep77120853strep_
streps86218063streps
strip77524343strip_
stripe85822443stripe
strips85719653strips
stript85222193stript
strop77422243strop_
stroppy14205093stroppy
strops86220383strops
stroy87720393str_oy
struck12489263struck
strum75619453stru_m
struma84313273struma
strums84716453strums
strung75213023strung
strunt64918913strunt
strut56030733stru_t
struts65616803struts
study94411793s_tudy
stumpy13458133stumpy
stupa74112313s_tupa
stupe75217753s_tupe
sturdy1037043sturdy
sunup7313053sunup_
sunups837263sunups
sup57041943s__up_
supe65932763s__upe
sups64834433s__ups
surely93816463surely
surety93515013surety
surfy115319473sur_fy
surgy95118523sur_gy
surly85124433sur_ly
surrey94414583surrey
survey124111673survey
swampy16437233swampy
sweepy14447453sweepy
swirly12439253swir_ly
swoopy14487283swoopy
syruped1334543syruped
tippy125411793ti_ppy
trippy13457803trippy
truly84111553_truly
unruly938083unruly
virus85316843viru_s
wicopy1634033wicopy
wimpy155911923wi_mpy
wirily123310783wirily
wiry106422833wir__y
wispy137210973wi_spy
zippy21518743zi_ppy

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.436409841.7
2DLD Change Limit1127162465.57620214.5
3Display Results2462460.0932645.2
 (SQL Overall)1786912466.10529269.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.