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

124 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
membered153590(None) 
cambered15129002cambered
cumbered15157962cumbered
limbered13158122limbered
lumbered13188232lumbered
mammered12237652mammered
member12258852member__
members13258602member_s
metered103514012me_tered
numbered13147142numbered
remembered1743352remembered
tempered13248222tempered
timbered13137382timbered
umbered121510112_umbered
barbered13259543barbered
beavered1437503beavered
bemired123410633bem_ired
bettered113011843bettered
bumpered1536003bumpered
centered112513523centered
chambered19145993chambered
clambered16146133clambered
compered153414923compered
cumberer14266993cumberer
demerged13157603dem_erged
demurred1234933demurred
dismembered1952853dismembered
embarked17205213_embarked
embarred13174793_embarred
embayed1535443_embayed
embed105014303_emb__ed
embedded1553313_embedded
ember95516803_ember__
embers104116183_ember_s
emblemed1544273_emblemed
embowed15236903_embowed
embowered1743413_embowered
embrued1235293_embrued
emceed1136283_emce_ed
emerged11158213_em_erged
emerod9139213_em_erod
emersed10138513_em_ersed
entered82718883_entered
fendered13258673fendered
festered122512113festered
fettered12259493fettered
fevered14339723fe_vered
fibered1337643_fibered
gendered11258873gendered
gettered10258613gettered
gibbered1444303gibbered
hammered16218853hammered
hampered16239933hampered
homebred16215893homebred
homered133212713hom_ered
jabbered2034433jabbered
jeered143912793je__ered
lechered1437523lechered
leered73816223le__ered
lettered92910783lettered
levered114212303le_vered
limberer12187053limberer
lumberer12177583lumberer
mamboed14417623mamb_oed
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
meandered1346143meandered
measured1136463measured
membraned1643903membraned
mentored1138003mentored
meseemed1343963meseemed
metred95315143me__tred
mimeoed1235193mim_eoed
mitered103213233m_itered
moldered1237173moldered
mongered1238953mongered
mothered142310103mothered
mumbled143010763mumb_led
murdered1236023murdered
mustered112511503mustered
muttered112610793muttered
neutered937423neutered
numberer12186313numberer
pampered15229233pampered
peered93819493pe__ered
peltered112510453peltered
peppered1236133peppered
pestered112814973pestered
petered103314973pe_tered
premiered14237093premiered
rebored105015883re_bored
rebred95816353re_b_red
rebreed104611073re_breed
rememberer1652623rememberer
remerged12149173rem_erged
rendered102512263rendered
renumbered15102863renumbered
revered112819333re_vered
rubbered1335383rubbered
sabered103213023_sabered
severed113513863se_vered
sewered112911243se_wered
simmered1336863simmered
simpered1338253simpered
slumbered14215593slumbered
sobered102912433_sobered
summered1338143summered
tabered103311593_tabered
tampered13279463tampered
teddered11255183teddered
teetered9258303teetered
telfered1234883telfered
temperer12227723temperer
tendered102510603tendered
tentered96412103tentered
tethered1238493tethered
umbeled12208193_umbeled
veered103612743ve__ered
veneered1235983veneered
weltered12238433weltered
westered122511873westered
yabbered1633963yabbered
yammered16225763yammered

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621247.50019488.3
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.99922339.2
 
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.