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 “bermes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
bermes10602300(None) 
berimes115216641berimes
berme96022941berme_
bermed115217721bermed
berms95323661berm_s
kermes124616131kermes
vermes115019141vermes
aeries64737782aeries
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barmen105418532barmen
barms96128462barm_s
barres84427542barres
baryes116218502baryes
beamed115720732beamed
beams95328172beam_s
becomes132911962becomes
becrimes1467072becrimes
bees65453382be__es
beeves114615042beeves
begrimes1376512begrimes
beiges91014412beiges
belies84631052belies
belles85325992belles
bemas96424282be_mas
benames112814602benames
benes75536232be_nes
bennes86019012bennes
berakes134815772berakes
berates94126872berates
beret74946362ber_et
berets85822522berets
bergs84718042ber_gs
berhymes1843802berhymes
berime105317332berime_
berimed124912282berimed
berks115423122ber_ks
berm86732752berm__
berries94423552berries
berths114712422berths
beryls11107882beryls
beses75830722be_ses
betimes115114412betimes
bevies114017302bevies
biomes103815252biomes
biremes1138772biremes
birles84920642birles
birses84717732birses
blames105121862blames
blumes105917792blumes
bores76448252bor_es
braes75735052b_raes
bredes94818472bredes
brees75632552b_rees
breves115516422breves
bries74942152b_ries
bromes104719762bromes
brumes106417072brumes
buries84633272buries
burkes124421312burkes
burses84425512burses
byres104421382byr_es
ceres75540012cer_es
cermet10321152cermet
cermets1139712cermets
certes84623082certes
cremes104517992cremes
demes86032692de_mes
dermas94116812dermas
dermis94717162dermis
derms85022892derm_s
emes65434662_e_mes
ernes55224812_ernes
erses55826802_erses
femes105626222fe_mes
femmes135410212femmes
feres86038182fer_es
fermis114313502fermis
formes114623712formes
germen9612312germen
germens1078632germens
germs85118872germ_s
hemes105031082he_mes
heres86245902her_es
herms105626432herm_s
heroes94923822heroes
herpes115517322herpes
kermess13396222kermess
kermis124012392kermis
kernes104717532kernes
memes94927702me_mes
merces105720742merces
merdes94518602merdes
meres75143572mer_es
merges94122492merges
merles85322762merles
mermen10813812mermen
nerves94216192nerves
neumes83112622neumes
peres76246642per_es
permed115217352permed
perms95524512perm_s
perses85428062perses
semes75731582se_mes
seres55448892ser_es
serges74225972serges
series64540972series
serves94423652serves
terces83921412terces
termed94816702termed
termer85717252termer
termers95414502termers
terms75523472term_s
ternes65422902ternes
thermes126214612thermes
verges104320182verges
vermis114214962vermis
verses94223762verses
verves124617882verves
zeroes154314342zeroes

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511222.67330883.3
3Display Results1221220.0304066.7
 (SQL Overall)1786911223.04658664.1
 
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.