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

116 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
marshiest143810(None) 
ashiest10313952_a_shiest
brashiest14359852brashiest
dashiest12311112da_shiest
earthiest1259102earthiest
harshest14310192harsh_est
marbliest1336762marbliest
marliest102415182mar_liest
marshes123615372marsh_es_
marshier1337592marshie_r
marshiness1555062marshiness
mashies12318252ma_shies_
massiest103314422ma_ssiest
meshiest132911032m_eshiest
mushiest133212872m_ushiest
trashiest123110632trashiest
washiest14310402wa_shiest
achiest12315183_a_chiest
arshins10312573_arshins_
artiest73121993_ar_tiest
artsiest879653_artsiest
banshies131110663banshies_
barghest1447913bargh_est
barkiest144115153bar_kiest
barmiest125212783bar_miest
barniest104815053bar_niest
brashest133511763brash_est
brassiest11369713brassiest
brushiest14297543brushiest
bushiest133512523_bushiest
catchiest1638313catchiest
cushiest133411043_cushiest
darkliest1435163darkliest
dishiest12313683_dishiest
earliest82415243ear_liest
earthliest1345393earthliest
easiest72318773ea_s_iest
farthest1499863farth_est
fishiest14310453_fishiest
flashiest1557983flashiest
fleshiest1576223fleshiest
gashest114813413ga_sh_est
gassiest93212523ga_ssiest
gorsiest92511133gors_iest
grassiest10309513grassiest
gushiest123510983_gushiest
hardiest123416333har_diest
harshness1545963harshness
hastiest112916493ha_stiest
horsiest112513263hors_iest
lardiest93813883lar_diest
larkiest123713313lar_kiest
lathiest11312653la_thiest
malmiest123211023ma_lmiest
maltiest102916193ma_ltiest
mangiest112815903ma_ngiest
manliest102314943ma_nliest
marches143921173march_es_
marchesa15346883march_esa
marchese15358913march_ese
marchesi15337323march_esi
marishes13512553marish_es_
marries93825283mar_ries_
marses84827113mars__es_
marshals1337783marshals_
mashes115030003ma_sh_es_
mashie11315933ma_shie__
matiest92522453ma__tiest
maziest183613873ma__ziest
measliest1147173measliest
merriest10311473mer_riest
messiest103112423m_essiest
miriest93619823mir__iest
mirkiest142910253mir_kiest
mistiest103018313m_istiest
mossiest103112443m_ossiest
mothiest13311033m_othiest
mousiest102711763mous_iest
mouthiest1438363mouthiest
murkiest143210263mur_kiest
murphies1536453murphies_
muskiest143311563m_uskiest
mussiest103112933m_ussiest
mustiest103017533m_ustiest
mythiest1636033m_ythiest
nastiest83615953na_stiest
pastiest103319543pa_stiest
patchiest1638353patchiest
plashiest1478373plashiest
plushiest1466393plushiest
pursiest102812123purs_iest
pushiest133211713_pushiest
rashest103916873ra_sh_est
raspiest10311273ra_spiest
rushiest113312923_rushiest
sarkiest123615063sar_kiest
sassiest83413613sa_ssiest
shiest95821523___shiest
sloshiest1246673sloshiest
slushiest1267033slushiest
smarmiest1335903smar_miest
starchiest1547183starchiest
swarthiest1644743swarthiest
swishiest1535513swishiest
tardiest93515243tar_diest
tarriest83215003tar_riest
tartiest82718313tar_tiest
tastiest83216633ta_stiest
torchiest1438033torchiest
vastiest112713073va_stiest
wariest105122503war__iest
warships1647553warships_
wartiest113614643war_tiest
waspiest1338813wa_spiest
worthiest1538323worthiest
wrathiest1536973wrathiest

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411168.01318550.0
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.23221706.9
 
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.