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

117 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
umlaut83803(None) 
umlauts943191umlauts
ablaut8313262ablaut
maut65448452_m_aut
umlauted1132822umlauted
ablauts936083ablauts
alant55742293_alant
aslant6317753aslant
beaut75135213_beaut
belaud939133belaud
blast76532573_blast
blat66550953_bla_t
clapt98027173_clapt
clast76030583_clast
clout75330463_clout
cumquat2044513cumquat
daut56443563__daut
eclat7523603ecla_t
flat77147823_fla_t
flaunt9712913_flaunt
flauta937823_flauta
flout86226203_flout
gelant72821673gelant
ghaut95919433_ghaut
glout65925813_glout
glut56331293_gl_ut
haut75949733__haut
imaum9139643im_aum
impact122310453impact
impart102715143impart
implant11311333implant
kraut95221403_kraut
kumquat2242903kumquat
last46260323__last
lat37593403__la_t
latu47934183__latu
laud56527723__laud
lout45952143__lout
malt66254813_m_alt
mart66865983_m_art
mast65959963_m_ast
mat58083943_m_a_t
matt65752663_m_att
maud75325403_m_aud
maul64830723_m_aul
maun65727213_m_aun
mauts75927193_m_auts
meant76537213_meant
meat66359603_mea_t
miaul71612123_miaul
moat66352033_moa_t
mulatto944733mulatto
mulct93820083mul_ct
mullet84126823mullet
mut58357183_m__ut
mutant8317693mutant
numbat10312083numba_t
oblast8613663oblast
outlast71015443outlast
pilau73618523pilau_
pilaus84114133pilaus
plait75631573_plait
plant75437113_plant
plat66048873_pla_t
pullout9310593pullout
slant55238703_slant
slat46959023_sla_t
slut45040593_sl_ut
smalt74729333sm_alt
smart75834093sm_art
smut66629783sm__ut
splat76129343spla_t
taut47048963__taut
uhlan849113uhla_n
uhlans937573uhlans
ulama7711473u_lama
ulan46527393u_la_n
ulans54921303u_lans
ullage739043ullage
ulu36028703u_l_u_
ululant747693ululant
ulus45622563u_l_us
umami939883um_ami
umiac938963umia_c
umiack1435173umiack
umiacs1035663umiacs
umiak1137673umia_k
umiaks1244953umiaks
umiaq1656823umia_q
umiaqs1733003umiaqs
umlauting1243163umlauting
unapt710421593u_napt
unau43924153u_nau_
unaus53216573u_naus
uncast84215713uncast
uncut73219173u_ncut
unhat81119263unha_t
unlace82215173unlace
unlade72714153unlade
unlaid7311753unlaid
unlash938793unlash
unlay84613703unla_y
unlays93810493unlays
unlet54133333unl_et
unlit55025463unl_it
unmeant9510903unmeant
unplait948603unplait
unshut939013unshut
upcast102710093upcast
updart9310743updart
upland938863upland
upleapt11116863upleapt
uplift114610653uplift
uplit76020803upl_it
upwaft1444943upwaft
volant9316323volant
walnut939433walnut

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161174.65624208.8
3Display Results1171170.0502340.0
 (SQL Overall)1786911175.09635065.0
 
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.