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

95 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
automat941487(None) 
automan9310881automan
automata1047961automata
automate10411941automate
automats10410441automats
autocrat1049282autocrat
automated1248812automated
automates11412052automates
automatic13410392automatic
automaton1145372automaton
automen939652automen
aboma91114603a_boma_
abomas101113583a_bomas
achromat15410103achromat
acrobat11411813acrobat
adwoman1345433adwoman
aerobat9514473aerobat
aerosat7417183aerosat
afloat9315153aflo_at
aftmost1244973aftmost
aftosa996573aftosa_
aftosas10147153aftosas
altoist7313393altoist
antifat10314253antifat
antiman9313883antiman
aroma71220143a_roma_
aromas81018613a_romas
asthma11126563asthma_
asthmas12117363asthmas
astomatal1144983astomatal
ataman81013063a_taman
atma68121773a_t_ma_
atman75520143a_t_man
atmas75721013a_t_mas
atom67824523a_tom__
atomic104115603a_tomic
atomist92915763a_tomist
atoms76817563a_tom_s
atomy107415193a_tom_y
atonal6514023a_tonal
attempt1145373attempt
aurora6411763aurora_
aurorae739663aurorae
auroral7310473auroral
auroras7311703auroras
autist64324943aut_ist
auto47432083auto___
autobahn1343533autobahn
autobus996513autobus
autocade1146683autocade
autocrats1147393autocrats
autoed7712823auto_ed
autogamy1454813autogamy
autograft1355793autograft
autoharp1343943autoharp
autoing8314043autoing
automaker1544663automaker
automatics1447783automatics
automating1389303automating
automation1249143automation
automatism14126433automatism
automatist12119053automatist
automatize2196563automatize
automatons1245373automatons
autonym1246633autonym
autopen947123autopen
autopsy1244373autopsy
autos56523323auto__s
autosomal1154003autosomal
autumn836013autum_n
autumnal1042393autumnal
autumns943763autumns
bathmat14510143bathmat
cocomat13413623cocomat
cutout8315923cuto_ut
nutmeat947953nutmeat
ostomate1049573ostomate
ottoman946283ottoman
outeat62824533out_eat
outman83115033out_man
outmost9511213outmost
outsat62920283out_sat
outsmart10168923outsmart
putout8315113puto_ut
stoat57135953_sto_at
stoma75918273_stoma_
stomal85213313_stomal
stomas84816323_stomas
stomata938533_stomata
stomate9313123_stomate
tautomer1044593tautomer
toman75724053__toman
tomato8313453__tomato
tomcat101013453__tomcat
utmost878483_utmost

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.410435831.7
2DLD Change Limit134027956.56020430.9
3Display Results95950.0332878.8
 (SQL Overall)178691957.00325516.4
 
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.