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

110 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
deviator124833(None) 
deviators1358551deviators
deviatory1666461deviatory
aviator10229682_aviator
decimator1447732decimator
dedicator1348252dedicator
deflator12328342deflator
delator83015032de_lator
depictor1355512depictor
depilator1247652depilator
deviate11312722deviat_e
deviated13311052deviated
deviates12312752deviates
deviation13312402deviation
devisor11357042devi_sor
evictor12346372_evictor
levator10298972lev_ator
levitator1245502levitator
mediator1139052mediator
obviator1344762obviator
viator93211842__viator
aerator7314853ae_rator
alleviator13103333alleviator
aviators11169923_aviators
avigator12236783_avigator
caveator1387233caveator
deaerator10128113deaerator
debater104114693de_bater
debtor938333de__btor
decimators1547503decimators
decorator1248573decorator
dedicators1447743dedicators
dedicatory1745673dedicatory
defeater122611663defeater
defecator1546383defecator
defector14277953defector
deflater123211603deflater
deflators13348153deflators
defoliator1444183defoliator
delators92314833de_lators
delegator1146243delegator
delineator1174173delineator
demeanor1143833demeanor
demister11310223demister
denigrator1245223denigrator
depicter1356853depicter
depictors1465943depictors
depilators1347333depilators
depilatory1645743depilatory
depurator1247023depurator
desiccator1543993desiccator
designator1244713designator
desolator1046673desolator
detector11278323detector
detonator1045983detonator
detractor12147213detractor
devastator1453143devastator
deviance1477083deviance
deviancy1754183deviancy
deviant11311313devia_nt
deviants1236743deviants
deviating14311093deviating
deviations14311173deviations
deviative1647733deviative
deviltry1542983deviltry
deviser114212393devi_ser
devisors12347253devi_sors
devouter1235513devouter
dewater112912423de_water
diatom939453d__iatom
dictator1147263dictator
dilator82712793d_ilator
divinatory1743943divinatory
divisor11345573divi_sor
dominator1258233dominator
donator8310263d_onator
editor738663_edi_tor
educator1147153educator
elevator1146723elev_ator
epilator1049243_epilator
equator1637483_equator
evertor1038723_evertor
evictors13276863_evictors
evocator1346573_evocator
expiator1747043expiator
fellator1176723fellator
genitor837273geni_tor
heritor10310563heri_tor
hesitator1286023hesitator
legator83011133le_gator
levators11249293lev_ators
levitators1345413levitators
mediators1248933mediators
mediatory1546443mediatory
meditator1246593meditator
navigator1364883navigator
negator83010673ne_gator
obviators1444863obviators
radiator949213radiator
relator74016383re_lator
remittor10316563remittor
resistor847683resistor
revelator1286543revelator
revisor10388743revi_sor
senator7313073se_nator
servitor1145073servi_tor
testator847373testator
viators102712033__viators
victor113210673__victor
vitiator1147043vitiator

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621107.42319690.4
3Display Results1101100.0601833.3
 (SQL Overall)1786911107.91922564.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.