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

142 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
surplus93679(None) 
purples112712832purples
sulus54821882su__lus
supples11511282supples
surpass938282surpass
surplused1243532surplused
surpluses1155432surpluses
aureus65314883aur_eus
aurous64119263aur_ous
bupkus14385683bu_pkus
burbles114916803burbles
bureaus979293bureaus
burgles105615963burgles
burls74228853bur_l_s
burnous938823burnous
burps94220173burp__s
carolus94612603carolus
carpus105514303carp_us
corpus106015293corp_us
cumulus1135453cumulus
cuprous1149743cuprous
curdles103814573curdles
curious93813563curious
curls74927103cur_l_s
earplug1042853earplug
earplugs1142243earplugs
euripus934623euripus
fumulus1234443fumulus
furious103110633furious
furls85322053fur_l_s
gurgles94312873gurgles
gurus64318193gur__us
hirples12149643hirples
hurdles113613373hurdles
hurls86522713hur_l_s
hurtles103913753hurtles
jurels133710583jurel_s
kurus98015633kur__us
lulus54315163lu__lus
lupous849433lu_pous
lupus74512523lu_p_us
murals84016763mural_s
nonplus936183nonplus
nurls55519683nur_l_s
overplus1336063overplus
peplus10138343_peplus
plus66324833___plus
pulpous1177013pulpous
pupus94614043pu_p_us
purfles122511853purfles
purls74723353pur_l_s
purple102712683purpl_e
purpled12299783purpled
purpler11289273purpler
purplest12249133purplest
purplish1554933purplish
purply13369053purpl_y
quippus20363543quippus
quipus17458003quip_us
rumples113313133rumples
rumpus10458893rump_us
samples112815453samples
sarcous9312933sarcous
sardius839553sardius
saurels749303saurel_s
scrolls938063scrolls
scruples1237433scruples
scyphus1743203scyphus
serious73616283serious
serous65023563ser_ous
shrills10389933shrills
simples113014943simples
slurps84410003slurp__s
solus54726983s__olus
sorels63921163sorel_s
sorus54527583sor__us
sourpuss1042313sourpuss
spurious1036963spurious
spurtles1037783spurtles
staples93617213staples
stratus73011733stratus
strolls739183strolls
stylus9397463s_tylus
subplot1158143subplot
subplots1255773subplots
subrules1039733subrules
suckles134516743suckles
sugarplum1471503sugarplum
sugarplums1561233sugarplums
sulcus8410493su_lcus
sulks94818463su__lks
sulphas1236243sulphas
sulphur12123883sulphur
sulphurs1383653sulphurs
sulu45128423su__lu_
sumps95023433sump__s
supers84622403su_pers
supes75628303su_p_es
suppers113314703suppers
supple10410203suppl_e
suppled1248463suppled
suppler1148443suppler
supplest1248953supplest
supplies1268843supplies
supply1346893suppl_y
sups64834433su_p__s
surahs94515543sur_ahs
sural55931263sural__
suras55336333sur__as
surds65624663sur__ds
surely93816463surel_y
surfers103614133surfers
surfs85022543sur__fs
surgers83517483surgers
surges73924593sur_ges
surimis938843surimis
surly85124433sur_l_y
surplice1246203surplice
surplices1346043surplices
surplusage1351083surplusage
surplusing1353343surplusing
surplussed1362123surplussed
surplusses1242843surplusses
surprise1037673surprise
surras65919533sur_ras
surreys10489443surreys
surtout7411683surtout
surtouts846203surtouts
surveys13357573surveys
swiples12339643swiples
tumulus935033tumulus
turps74918733turp__s
turtles72914343turtles
ulus45622563_u__lus
unplug954413_unplug
unplugs1042983_unplugs
uraeus638793_uraeus
urps66920483_urp__s
urus46426143_ur__us
usurious845273usurious
usurpers1033743usurpers
usurps8105073usurp__s

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271426.12321889.1
3Display Results1421420.0502840.0
 (SQL Overall)1786911426.57927160.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.