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

88 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
autumns94376(None) 
autumn836011autumn_
auburns935572auburns
aurums849382aurum_s
autumnal1042392autumnal
actins86321103act_ins
actions94218513actions
acumens1136953a_cumens
albumens1244143albumens
albumins1245353albumins
albums10198273album_s
algums9208043algum_s
alumins9512983a_lumins
alumna857343a_lumna
alumni856753a_lumni
alumnus935223a_lumnus
alums75720603a_lum_s
antrums969173antrum_s
arums75517833a_rum_s
assumes967163assumes
asthmas12117363asthmas
atamans9710433a_tamans
atmans84413963a_tmans
atmas75721013a_t_mas
atoms76817563a_tom_s
attains7310983attains
attorns738443attorns
attune637983attu_ne
attunes737823attunes
auburn836213auburn_
auctions104012143auctions
aucubas1145173aucubas
augurs7399963augu_rs
aurum7614963aurum__
ausubos942943ausubos
auteurs7137503auteurs
authors10311853authors
autisms94311553autisms
autists73814853autists
autobus996513autobus
autoing8314043autoing
automan9310883automan
automat9414873automat
automats10410443automats
automen939653automen
autopens1046633autopens
autos56523323aut__os
auxins13129813au_xins
bitumens1243523bitumens
buttons9310333buttons
bututs8409423butu_ts
cautions103313183cautions
columns1136473columns
cutins83919983cut_ins
cutups1036813cutu_ps
datums936353datum_s
durums948153durum_s
futons93911513fut_ons
futures10310263futures
inturns73210133inturns
jugums16104673jugum_s
luteins7310103luteins
metumps1334133metumps
mutons84314363mut_ons
muttons949283muttons
mutuals937123mutuals
mutuels935943mutuels
mutules9311843mutules
outburns1036063outburns
outguns8318693outguns
outjumps1942603outjumps
outmans92413283outmans
outruns72911543outruns
outsins73417863outsins
outturns835913outturns
putons83515153put_ons
returns79712593returns
rutins63818393rut_ins
stumps104912283_stumps
stums75320083_stum_s
stuns54719493_stu_ns
sutures7314223sutures
tautens7317843taut_ens
tumps95420793__tumps
tuns45138663__tu_ns
turns55623243__turns
tutus55214813tutu__s
upturns9264973upturns

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 Filter1786911340270.406440125.6
2DLD Change Limit134027886.87319500.5
3Display Results88880.0332666.7
 (SQL Overall)178691887.31224438.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.