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

218 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
spryest1224781(None) 
spriest92718641spriest
dryest104811122_dryest
prest75736352_pr_est
priest84125422_priest
sayest94217742s_ayest
serest64831612ser_est
shyest125511832s_hyest
slyest93811362s_lyest
sorest65027992sor_est
sparest94616422sparest
sparsest1048812sparsest
spiriest102513452spiriest
sprees85620642sprees_
sprent84522382spr_ent
sprucest12295782sprucest
sprues84515762sprues_
spryer11418532sprye_r
spryness1334002spryness
surest65026762sur_est
wryest12429112_wryest
aeriest73924053aeriest
airest63825263air_est
airiest74221013airiest
apres75426403apr_es_
aptest82917513ap_test
arrest63722633_arrest
barest85327693bar_est
baryes116218503baryes_
coyest11316053_coyest
crest74632693_cr_est
curtest9713963curtest
darkest122512623darkest
direst75024243dir_est
drest65530343_dr_est
driest74722753_driest
earnest7318733earnest
eeriest73620673eeriest
feyest12311403_feyest
firmest1239273firmest
forest94926743for_est
freest95318283_freest
gayest104314333_gayest
goriest82218743goriest
grayest11489363grayest
greyest11348343greyest
hardest113118413hardest
harvest132112753harvest
imprest11310203impr_est
largest83715103largest
mayest114614793_mayest
merest84725113mer_est
miriest93619823miriest
mirkest13309723mirkest
murkest133110203murkest
openest9312913openest
ospreys1233143ospreys_
palest83926223_palest
pertest9317043pertest
pest65555293_p__est
prees75937173_prees_
presa74319043_pr_esa
prese75228383_pr_ese
preset84430983_pr_eset
press75425953_pr_ess
presto84216203_pr_esto
prests84021263_pr_ests
pretest9517633_pretest
preys105717783_preys_
pries74339533_pries_
priests93810863_priests
prost75434103_pr_ost
protest9317533_protest
prowest12311533_prowest
pryer104415313_prye_r
pryers115012243_pryers
purest84021933_purest
pyes95528993_p_yes_
pyres105523883_pyres_
rarest65725483rar_est
reest54938093__reest
rest46459843__r_est
ryes75529353__ryes_
saddest92412383saddest
safest95016603s_afest
sagest74920263s_agest
sagiest82617983sagiest
saltest71916513saltest
sanest64426693s_anest
sappiest122612573sappiest
sarees65329943sarees_
sarges75128593sarges_
sarkiest123615063sarkiest
sarment9318763sarment
sayst85322003s_ay_st
scarcest12169173scarcest
scariest101615943scariest
screes85023963screes_
scries85226823scries_
searest73322023searest
serenest82717623serenest
seres55448893ser_es_
serges74225963serges_
series64540973series_
serpent92916283serpent
serves94423653serves_
sexiest142112223sexiest
sharpest1339143sharpest
shiest95821523s_hiest
shortest11310773shortest
sickest131813793sickest
sirees64624583sirees_
sires55945373sir_es_
siziest16311473siziest
sliest66621943s_liest
slowest10168713slowest
smartest10310183smartest
snidest8310913snidest
snyes85012753s_nyes_
softest10310603softest
soonest7415593soonest
soppiest122511933soppiest
sorbent92915233sorbent
sorbet83924073sorbe_t
sorbets93012503sorbets
sores55454283sor_es_
sorriest8413883sorriest
sourest7515713sourest
spaces104722633spaces_
spaciest122310893spaciest
spades94222583spades_
spaes76029973sp_aes_
spales84728103spales_
spares84834553spares_
sparges104016333sparges_
sparkiest15188093sparkiest
sparriest11198783sparriest
spates85028173spates_
spayed124213613spaye_d
spays105520513spay_s_
spelt75430193sp__elt
spent75532833sp__ent
spheriest1438373spheriest
spices104326033spices_
spiciest122711603spiciest
spies76037623sp_ies_
spikes124520713spikes_
spikiest14259533spikiest
spiles84227913spiles_
spines85132033spines_
spinet85629753spine_t
spinets94714813spinets
spiniest102813223spiniest
spires84628113spires_
spites84127333spites_
splent84720193sp_lent
spodes94817433spodes_
spokes124417213spokes_
spores84726613spores_
sportiest111711023sportiest
sprags95715823sprags_
sprat76635973spr__at
sprats85819933sprats_
sprayed13398903spraye_d
sprayer12369043spraye_r
sprayers13367053sprayers
sprays115913643sprays_
spread9312533spr_ead
spree74830863spr_e_e
sprier84119063sprie_r
spright132010403spright
sprigs94814773sprigs_
sprint84526793spr_int
sprints94113773sprints
sprit76736403spr__it
sprites94220333sprites_
sprits85122533sprits_
sprout8419403spr_out
sprouts949983sprouts
spruces113810503spruces_
spruciest1345143spruciest
sprue74717633sprue__
sprugs94010173sprugs_
spry96819123spry___
spryly1435513spry_ly
spues75025383sp_ues_
spumes1021314883spumes_
spumiest1238193spumiest
spurges104111653spurges_
stalest73720173stalest
starkest1239723starkest
sternest8314433sternest
street64125773str_eet
streets73312613streets
stress66616673str_ess
styes86316523s_tyes_
suavest10310623suavest
subtest9513963subtest
suggest9310863suggest
superbest1349963superbest
supplest1248933supplest
supremest1347033supremest
surfeit10310343surfeit
surfiest112414423surfiest
surges73924593surges_
surliest82416903surliest
tartest72517533tartest
tersest71713993tersest
truest64816193_truest
tryst84716223_try_st
unrest62918853unr_est
veriest103719133veriest
wariest105122503wariest
warmest123113033warmest
wiriest103816853wiriest
wrest84925433_wr_est
wriest94419713_wriest
yarest95018913yar_est

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272187.25018486.5
3Display Results2182180.0762868.4
 (SQL Overall)1786912187.48223882.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.