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

119 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
autumn83601(None) 
autumns943761autumns
auburn836212auburn
aurum7614962aurum_
aurums849382aurums
automan9310882automan
automen939652automen
autumnal1042392autumnal
acetum1038463acetum_
actin74922553act_in
action84719683action
actual8311023actual
acumen1049013a_cumen
adytum1243733adytum_
album92312653album_
albumen1135243albumen
albumin1145563albumin
albums10198273albums
algum82711763algum_
algums9208043algums
alum65227613a_lum_
alumin8513543a_lumin
alumna857343a_lumna
alumni856753a_lumni
alums75720603a_lums
antiman9313883antiman
antrum8611313antrum_
antrums969173antrums
arum66129033a_rum_
arums75517833a_rums
assume897563assume
astern64815813astern
asthma11126563asthma
astute6310763astute
ataman81013063a_taman
atma68121773a_t_ma
atman75520143a_tman
atom67824523a_tom_
atoms76817563a_toms
atomy107415193a_tomy
attain6311753attain
attorn6310793attorn
attune637983attune
auburns935573auburns
auction93412933auction
aucuba1045493aucuba
augur64311213augu_r
augurs7399963augurs
augury10366663augury
august739203august
ausubo853653ausubo
auteur6107943auteur
auteurs7137503auteurs
author939763author
autism83815333autism
autisms94311553autisms
autist64324943autist
auto47432083aut__o
autoed7712823autoed
autoing8314043autoing
automat9414873automat
autopen947123autopen
autos56523323aut_os
auxin121411913au_xin
bitumen1134503bitumen
button8310273button
butut75522913butu_t
bututs8409423bututs
caution93013523caution
column1038103column
cutin75022783cut_in
cutup9410093cutu_p
cutups1036813cutups
datum8310633datum_
datums936353datums
durum8513203durum_
durums948153durums
fusuma1134503fusuma
futon83113773fut_on
future939563future
inturn63411563inturn
jugum15167473jugum_
jugums16104673jugums
lutein6311263lutein
luteum837783luteum_
metump1235713metump
muton73817003mut_on
mutton8510453mutton
mutual838503mutual
mutuel837823mutuel
mutule8311423mutule
notum7611693notum_
outburn936903outburn
outgun7349643outgun
outjump1843773outjump
outman83115033outman
outran63218893outran
outrun63213303outrun
outsin63617563outsin
outturn737123outturn
putamen1135923putamen
puton73617913put_on
return623222523return
rutin55421343rut_in
scutum1036373scutum_
sputum1035943sputum_
stum65526023_stum_
stump94616463_stump
stums75320083_stums
stun45623453_stu_n
suture6313203suture
tauten64311893taut_en
tump85927033__tump
tun35845193__tu_n
turn46330393__turn
tutu48423173tutu__
tutued7349413tutued
tutus55214813tutu_s
upturn8286243upturn

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.373479064.3
2DLD Change Limit1127161195.44020719.9
3Display Results1191190.0462587.0
 (SQL Overall)1786911195.85930498.5
 
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.