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

171 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
strappy1420526(None) 
scrappy16234471scrappy
stroppy14205091stroppy
crappy15446802_crappy
sappy125413472s__appy
satrapy12497932satra_py
snappy1366102s_nappy
strap77925262stra_p_
strapped1357822strapped
strapper1258092strapper
straps87721782stra_ps
strawy1210312822stra_wy
stray88525572stra__y
stripy115812742str_ipy
trampy13499252_trampy
trippy13457802_trippy
astrally1148883astrally
astray95615543astra__y
atrophy1546183atrophy
crampy154710993_crampy
drapey125010583_drapey
drippy14445653_drippy
estray95713333estra__y
flappy1654483_flappy
frappe13286953_frappe
gappy136212033__gappy
grapey126012303_grapey
grappa11396443_grappa
grapy115416433_gra_py
grippy14447763_grippy
happy155813533__happy
nappy126312333__nappy
pappy114713803__pappy
preppy1235523_preppy
raspy106511703__raspy
sarape84817573sara_pe
sarapes94617743sarapes
satrap86212553satra_p_
satraps95011643satra_ps
schappe1635263schappe
scraggy14304583scraggy
scrap97120403scra_p_
scrape105917573scra_pe
scraped124313133scraped
scraper114513413scraper
scrapes116217663scrapes
scrapie115010943scrapie
scrapped1556533scrapped
scrapper1466963scrapper
scrappily1842673scrappily
scrapple1434683scrapple
scraps106017243scra_ps
scrawly15197183scrawly
scrawny15213933scrawny
scrimpy16486133scrimpy
serape84818413sera_pe
serapes95218103serapes
seraph114011163sera_ph
seraphs12408093seraphs
sharply15406833sharply
sharpy145211033s_harpy
shnapps1463343shnapps
shrimpy17415403shrimpy
sirupy11377053sir_upy
slippy1375843s_lippy
sloppy1395303s_loppy
snippy1374843s_nippy
soapy106114783s_oa_py
soppy125113523s__oppy
sprawly15166043sprawly
spray106720063spra__y
stably113314123st_ably
stagey105915583st_agey
staggy115510393st_aggy
stagy96618893st_a_gy
stalky13499303st_alky
stamp95217363st_amp_
stamps105614023st_amps
stapes85028733st_apes
staph104314653st_a_ph
staphs114411033st_aphs
staple84415823st_aple
starchy15286743starchy
starkly14277033starkly
starry94911673st_arry
startsy10536703startsy
stay78333723st_a__y
steady103510203stea_dy
steamy115112373stea_my
steeply1236293steeply
steppe10319873st_eppe
strafe95215983stra_fe
strafed114413333strafed
strafer103912463strafer
strafes104516003strafes
straggly13355563straggly
strain64919573stra_in
strains74218153strains
strait64025893stra_it
straitly1136563straitly
straits74916323straits
strake104017393stra_ke
straked125415343straked
strakes114218073strakes
stramony1344933stramony
strand74514823stra_nd
strands83711953strands
strang75718313stra_ng
strange85416343strange
strappado1451753strappado
strappers1346743strappers
strappier1345133strappier
strapping1436993strapping
strass67117223stra_ss
strata63616283stra_ta
stratal72710603stratal
stratas73013583stratas
strategy1244363strategy
strath93216373stra_th
straths102711723straths
strati63518893stra_ti
stratify1445703stratify
stratum9318243stratum
stratus73011733stratus
straw813321293stra__w
strawed114813613strawed
straws98718673stra_ws
strayed114513283strayed
strayer104312503strayer
strays96417933stra_ys
streaky14447813streaky
streamy12509483streamy
strep77120853str_ep_
streps86218063str_eps
stringy114111073stringy
strip77524333str_ip_
stripe85822443str_ipe
striped105214363striped
striper94514793striper
stripes95320573stripes
stripped1357093stripped
stripper1247123stripper
strips85719653str_ips
stript85222193str_ipt
strop77422243str_op_
strophe1239143strophe
stropped1367343stropped
stropper1247763stropper
strops86220383str_ops
stroy87720393str__oy
stumpy13458133st_umpy
swampy16437233s_wampy
syrupy14285823syr_upy
teapoy1138113_teapoy
tippy125411793_t_ippy
tramp96319773_tramp_
tramps105114453_tramps
tranny94210863_tranny
trap67532803_tra_p_
trapan82412973_trapan
trapes85024463_trapes
trapped124512213_trapped
trapper113912803_trapper
traps75727483_tra_ps
trapt76433393_tra_pt
trashy12509053_trashy
tray77632593_tra__y
triply114211023_triply
trophy1438283_trophy
unhappy1742803unhappy
zappy21548943__zappy

Search took 9 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.1561145455.1
2DLD Change Limit1340271718.31316122.6
3Display Results1711710.0632714.3
 (SQL Overall)1786911718.53220943.6
 
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.