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

126 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
malmsey143362(None) 
malmseys1541901malmseys
malmier113611952malmier
malms95021552malms__
malmy124816342malm__y
mamey125418832ma_m_ey
mammey124310892ma_mmey
alley85721673_al_ley
alme65832163_alm_e_
almeh106214553_alm_eh
almes75126543_alm_es
almner85710723_almner
alms65834923_alms__
almsmen1144583_almsmen
balases93815433balases
ballsy11508873balls_y
balmier113811513balmier
balmily14216463balmily
balms95723923balms__
balmy125217473balm__y
baloney1237483baloney
calmed114816383calm_ed
calmer105216933calm_er
calmest11312343calmest
calmly1337613calm_ly
calms95222353calms__
causey113513273ca_usey
damsel9148033da_msel
false84818123fal_se_
falsely1336013fal_sely
falser93912413fal_ser
filmset1257513filmset
galley104215453gal_ley
gamey115320553ga_m_ey
halms105225213halms__
madmen113511743madm_en
maguey1236833ma_guey
mailmen1137273mailm_en
maimed114812663maim_ed
maimer104514593maim_er
maims96321783maims__
majesty1943503majesty
malady1237863mal_ady
malaise9312673malaise_
malaises10312333malaises
malarkey1743403malarkey
malarky1645433malarky
malate84624553malate_
malates93522603malates
male66052293mal__e_
males75049793mal__es
malfed12369753mal_fed
malgre9299303malgre_
malice104818483malice_
malices114316623malices
maline84529083maline_
malines93625603malines
malison939693malison
malled94626103mal_led
mallee84525593mal_lee
mallees93315973mallees
mallei84414633mal_lei
mallet84433053mal_let
malls76233433malls__
malm85129973malm___
malmiest123211023malmiest
malposed1344563malposed
maltase938903maltase_
maltases1039693maltases
malted94819853mal_ted
maltier93015483maltier
maltose939783maltose_
maltoses1039853maltoses
malts76331753malts__
maltster1035303maltster
malty106721703mal__ty
mameys13449523ma_m_eys
mamie95826003ma_mie_
mamies104626243ma_mies
mammae94613213mammae_
mammary1335993mammary
mammee94417853ma_mmee
mammees104411143mammees
mammer94218863ma_mmer
mammet94319253ma_mmet
mammeys13376723ma_mmeys
mammie94313783mammie_
mammies104314763mammies
mammy115215163ma_m_my
mamzer19459833ma_mzer
mangey123614523ma_ngey
manse75528223ma_nse_
manses84225513ma_nses
marmoset12411983marmoset
marse76231153ma_rse_
marses84827113ma_rses
marshy14558333ma_rshy
maser75029973ma__ser
mashy136016503ma__shy
masse75125293ma_sse_
massed94421323ma_ssed
masses85028713ma_sses
massy104518963ma__ssy
matey107022663ma__tey
maumet103518883maum_et
mavises122812993mavises
momser104011413m_omser
mosey105922873m__osey
mousey115216193m_ousey
muley104819283mul__ey
mulley114013453mul_ley
palfrey1533343palfrey
palmary14338553palmary
palmed114314643palm_ed
palmer105816543palm_er
palmier113312173palmier
palms94921753palms__
palmy126016733palm__y
palsy105417463pal_s_y
taluses7311213taluses
valise92917643valise_
valises103516263valises
valley124311603val_ley
valse85117523val_se_
valses94514613val_ses
whimsey18373893whimsey

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 Limit1340271267.15618729.3
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.35824285.3
 
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.