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

104 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
umlauted113282(None) 
umlaut838032umlaut__
umlauts943192umlaut_s
ablated102513443abla_ted
abluted10188363abl_uted
alated75625153_ala_ted
belated103520013bela_ted
belauded1244793belauded
blasted104213473_blasted
blatted104812713_blatted
clouted104212163_clouted
cumulated14237843cumula_ted
dauted84114933__dauted
delated93722873dela_ted
dilated93115823dila_ted
diluted9248933dil_uted
elated74725823_ela_ted
eluted74915263_el_uted
embruted1344353embruted
emulated11310793emula_ted
flatted114012943_flatted
flaunted1234603_flaunted
flouted113210813_flouted
fluted104917163_fl_uted
gelated93615643gela_ted
glouted9429713_glouted
imbruted1343693imbruted
impacted15286353impacted
imparted13248063imparted
impasted13297553impasted
implanted1475493implanted
imputed1236533im_puted
lasted74323603__lasted
lated65240673__la_ted
lauded83812153__lauded
louted74920693__louted
luted64826143__l_uted
malted94819863_m_alted
marted94425213_m_arted
masted94025803_m_asted
mated85537783_m_a_ted
matted94521413_m_atted
mauled94817823_m_auled
meated94222403_mea_ted
miauled1036663_miauled
minuted10329503_minuted
moated94819003_moa_ted
mulcted12296693mul_cted
mutated102712253muta_ted
muted85023383_m__uted
outlasted10128353outlasted
plaited103713893_plaited
planted103516123_planted
plated95225773_pla_ted
platted103614263_platted
polluted1135433polluted
related83327573rela_ted
saluted84511713sal_uted
sauted74119603__sauted
slanted83514743_slanted
slated75028313_sla_ted
slatted84015183_slatted
smarted105012613sm_arted
solated83618023sola_ted
splatted11356743splatted
sublated11311503subla_ted
summated13298833summa_ted
tauted75317113__tauted
ullaged937033ulla_ged
ululated947663ulula_ted
umlauting1243163umlauting
unacted10312733u_nacted
unbasted112510073unbasted
unbated103317733unba_ted
uncarted11312053uncarted
uncaused1138453uncaused
undated93118463unda_ted
undaunted1145453undaunted
unfluted1237173unfluted
ungated92717213unga_ted
unhatted1238183unhatted
unlaced102913733unla_ced
unladed92614373unla_ded
unlashed12289183unlashed
unletted9310313unletted
unlisted9311153unlisted
unmated103317023unma_ted
unmatted1138293unmatted
unparted11310823unparted
unplaited1236883unplaited
unplanted1236853unplanted
unrated82621553unra_ted
unsalted9510923unsalted
unsated83419933unsa_ted
untasted92011573untasted
unwanted12249603unwanted
unwasted12259783unwasted
updarted1244313updarted
updated11369423upda_ted
uplifted1454423uplifted
uprated103213323upra_ted
upwafted1742193upwafted
valuated12239203valuated
voluted11297943vol_uted

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 Filter1786911461620.483369960.7
2DLD Change Limit1461621047.23620199.3
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.76523012.4
 
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.