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 “umlauts” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
umlauts94319(None) 
umlaut838031umlaut_
ablauts936082ablauts
mauts75927192_m_auts
umlauted1132822umlauted
ablaut8313263ablaut_
alants67722023_alants
beauts86015283_beauts
belauds1036643belauds
blasts85116773_blasts
blats75132503_bla_ts
clasts84817293_clasts
clouts87017203_clouts
cumquats2142833cumquats
dauts67822243__dauts
eclats8313033ecla_ts
flats86429743_fla_ts
flatus94310783_flatus
flaunts1056133_flaunts
flauta937823_flauta
flautas1036153_flautas
flouts94315273_flouts
gelants82611443gelants
ghauts10447783_ghauts
glouts74414713_glouts
gluts66120133_gl_uts
imaums10106303im_aums
impacts13266503impacts
imparts11298533imparts
implants1237883implants
krauts10418513_krauts
kumquats2341723kumquats
lasts57731263__lasts
lats45962703__la_ts
lauds65618483__lauds
louts56330273__louts
malts76331753_m_alts
marts77442233_m_arts
masts77035763_m_asts
mats65460293_m_a_ts
matts76829183_m_atts
mauds85519273_m_auds
mauls76524953_m_auls
maut65448453_m_aut_
meats75034053_mea_ts
meatus85112923_meatus
miauls8178713_miauls
moats75827643_moa_ts
mulatto944733mulatto
mulattos1044083mulattos
mulcts10298713mul_cts
mullets93614783mullets
mutants938583mutants
muts64839983_m__uts
numbats1137673numba_ts
oblasts947303oblasts
outlasts8108713outlasts
pilaus84114133pilau_s
plaits83816473_plaits
plants84921803_plants
plats75531373_pla_ts
pullouts1045223pullouts
slants64819083_slants
slats55436903_sla_ts
sluts54523983_sl_uts
smalts85214893sm_alts
smarts86218003sm_arts
smuts75415713sm__uts
splats84817303spla_ts
tauts56125513__tauts
uhlans937573uhla_ns
ulamas8910453u_lamas
ulans54921303u_la_ns
ullages838953ullages
ulus45622563u_l_u_s
umamis1038273um_amis
umiacks1534013umiacks
umiacs1035663umia_cs
umiaks1244953umia_ks
umiaqs1733003umia_qs
umlauting1243163umlauting
unaus53216573u_nau_s
unhats91110623unha_ts
unlaces92513623unlaces
unlades82612833unlades
unlays93810493unla_ys
unplaits1044813unplaits
upcasts11185643upcasts
updarts1034203updarts
uplands1036943uplands
uplifts12424773uplifts
upwafts1541943upwafts
walnuts1033843walnuts

Search took 7 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.390458182.1
2DLD Change Limit134027936.29621287.6
3Display Results93930.0332818.2
 (SQL Overall)178691936.71926594.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.