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

180 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
syrupy1428582(None) 
sirupy11377051sirupy
syrup103010961syrup_
syrups11277951syrups
sirup74014912sirup_
sirups83710532sirups
soupy106115402s_oupy
sprucy13356322sprucy
stripy115812742stripy
syruped1334542syruped
abrupt1039943abrupt
crepy124812703_crepy
croupy13458733croupy
drupe85012993_drupe
erupt74220063_erupt
eyry106315883eyr__y
frumpy16466883_frumpy
grapy115416433_grapy
gripy115115253_gripy
grumpy14498153_grumpy
gyrus95310803gyru_s
harpy136418203har_py
irrupt846993irrupt
koruny1334443koruny
myopy15457353my_opy
occupy1543153occupy
pyrope132810533pyrope
ropy96323413__ropy
roupy106112713_roupy
ruby97819943__ruby
ruly76323143__ruly
sappy125413473s_appy
sarape84817573sarape
sarky125521783sar_ky
satrapy12497933satrapy
saucy104615163s_aucy
saury84317223s_aury
scaup95515993scaup_
scaups105411933scaups
scrap97120403scrap_
scrape105917573scrape
scrappy16234473scrappy
scraps106017243scraps
screwy14659453screwy
scrimpy16486133scrimpy
scrip96619193scrip_
scrips105316033scrips
script105717903script
scrub94914203scru_b
scrubby1642803scrubby
scrubs104210313scrubs
scruff1437963scruff
scruffy1842643scruffy
scrum95418193scru_m
scrums104614253scrums
scruple1137193scruple
scry96017763scr__y
scup84822383s_cup_
scups95316653s_cups
scurfy14338763scurfy
scurry11419583scurry
scurvy14386103scurvy
seepy104717973s_eepy
serape84818413serape
seraph114011163seraph
serry84824123ser_ry
serum75223473seru_m
serums83916303serums
setup73915823setup_
setups83910463setups
sharpy145211033sharpy
shlumpy1742863shlumpy
shrimpy17415403shrimpy
shrub104814893shru_b
shrubby1742363shrubby
shrubs11409213shrubs
shrug94512513shru_g
shrugs10469163shrugs
shrunk13357063shrunk
siruped1036013siruped
situp74414063situp_
situps8538783situps
skimpy17475723skimpy
sleepy11479413sleepy
slippy1375843slippy
sloppy1395303sloppy
slurp74014983slurp_
slurps84410003slurps
slurry9378593slurry
snappy1366103snappy
snippy1374843snippy
snoopy11449473snoopy
snouty9419953snouty
soapy106114783s_oapy
soppy125113523s_oppy
sorely94618003sorely
sorry84618253sor_ry
sorus54527583soru_s
soup66232913s_oup_
soups75322943s_oups
sourly93612203sourly
spray106720063spr_ay
spruce103910873spruce
sprue74717633spru_e
sprues84515763sprues
sprug85313893spru_g
sprugs94010173sprugs
sprung94610033sprung
spry96819123spr__y
spryly1435513spryly
spumy124610363s_pumy
spurry11429113spurry
spy86023743s___py
stoup75517073stoup_
stoups85313273stoups
stoury9529943stoury
strap77925263strap_
strappy14205263strappy
straps87721783straps
strawy1210312823strawy
stray88525573str_ay
strep77120853strep_
streps86218063streps
strip77524333strip_
stripe85822443stripe
strips85719653strips
stript85222193stript
strop77422243strop_
stroppy14205093stroppy
strops86220383strops
stroy87720393str_oy
struck12489263struck
strum75619443stru_m
struma84313273struma
strums84716453strums
strung75213023strung
strunt64918913strunt
strut56030733stru_t
struts65616803struts
study94411793s_tudy
stumpy13458133stumpy
stupa74112313s_tupa
stupe75217753s_tupe
sturdy1037043sturdy
sunup7313053sunup_
sunups837263sunups
sup57041943s__up_
supe65932763s__upe
sups64834433s__ups
surely93816453surely
surety93515003surety
surfy115319473sur_fy
surgy95118523sur_gy
surly85124423sur_ly
surrey94414573surrey
survey124111663survey
swampy16437233swampy
sweepy14447453sweepy
swoopy14487283swoopy
sylph1347793sy_lph
sylphy1744153sylphy
synura935983synura
syph125413273sy__ph
syren85216743syr_en
syrens94911993syrens
syrinx1637143syrinx
syrupier1343053syrupier
syruping1434253syruping
sysop1037193sysop_
sysops1136013sysops
syzygy2141113syzygy
truly84111553_truly
typy126013043ty__py
unruly938083unruly
yaup96618483_yaup_
yaups105910743_yaups
yeuky15547033_yeuky
yup86031703_y_up_
yuppy15487913_yuppy
yups96121603_y_ups

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.190940478.9
2DLD Change Limit1127161806.48317386.4
3Display Results1801800.0632857.1
 (SQL Overall)1786911806.73626527.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.