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

131 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
automan931088(None) 
automat9414871automat
automen939651automen
adwoman1345432adwoman
antiman9313882antiman
ataman81013062a_taman
atman75520142a_t_man
autobahn1343532autobahn
automata1047962automata
automate10411942automate
automaton1145372automaton
automats10410442automats
autopen947122autopen
autumn836012autum_n
ottoman946282ottoman
outman83115032out_man
toman75724052__toman
abdomen1237023abdomen
aboma91114603a_boma_
abomas101113583a_bomas
adman84517903a__dman
adwomen1345683adwomen
aftosa996573aftosa_
aftosas10147153aftosas
agnomen1036763agnomen
aidman92410623a_idman
airman82414223a_irman
airwoman1344673airwoman
ajowan1634893a_jowan
alloxan1445773alloxan
almsman1145093almsman
antiwoman1446133antiwoman
aroma71220143a_roma_
aromas81018613a_romas
artisan759463artisan
ashman1148383a_shman
asthma11126563asthma_
asthmas12117363asthmas
atamans9710433a_tamans
atma68121773a_t_ma_
atmans84413963a_t_mans
atmas75721013a_t_mas
atom67824523a_tom__
atomic104115603a_tomic
atoms76817563a_tom_s
atomy107415193a_tom_y
atonal6514023a_tonal
attorn6310793atto_rn
aurora6411763aurora_
aurorae739663aurorae
auroral7310473auroral
auroras7311703auroras
aurorean844883aurorean
auto47432083auto___
autobahns1443053autobahns
autobus996513autobus
autocade1146683autocade
autocrat1049283autocrat
autodyne1243823autodyne
autoed7712823auto_ed
autogamy1454813autogamy
autogeny1245233autogeny
autoharp1343943autoharp
autoing8314043autoing
automaker1544663automaker
automated1248813automated
automates11412053automates
automatic13410393automatic
automating1389303automating
automation1249143automation
automatons1245373automatons
autonym1246633autonym
autopens1046633autopens
autopsy1244373autopsy
autos56523323auto__s
autosomal1154003autosomal
autumnal1042393autumnal
autumns943763autumns
axeman1538103a_xeman
axman144813183a__xman
batman105214063bat_man
batsman1157993batsman
bushman1455693bushman
busman10310253bu_sman
dustman1044683dustman
dutchman1643013dutchman
earthman1346473earthman
footman1236403footman
futon83113773futo__n
gateman1057473gateman
gunman9299453gu_nman
hetman112510603het_man
hitman112710223hit_man
human102716033hu__man
huntsman1343863huntsman
junkman2043173junkman
juryman1943583juryman
laywoman1643363laywoman
madwoman1643693madwoman
motorman1246143motorman
muton73817003muto__n
ortolan747083ortolan
ottomans1044493ottomans
outmans92413283out_mans
outplan9249443outplan
outran63218893out_ran
outspan938743outspan
pitman102412123pit_man
potman102813573pot_man
ptomain1146963_ptomain
pullman1135403pullman
putamen1135923putamen
puton73617913puto__n
radioman1145773radioman
raftsman1344163raftsman
roman75424823__roman
routeman10135493routeman
soman75024903__soman
stoma75918273_stoma_
stomal85213313_stomal
stomas84816323_stomas
surfman1236203surfman
tautomer1044593tautomer
titman82711003tit_man
tolan55124013__tolan
tomans85419133__tomans
turfman1243983turfman
unman72715423_u_nman
utopian9126273_utopian
woman105818003__woman
yeoman1138823_yeoman

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.1561145455.1
2DLD Change Limit1340271316.36021073.4
3Display Results1311310.0462847.8
 (SQL Overall)1786911316.56227231.2
 
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.