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
deviator124831(None) 
deviators1358531deviators
deviatory1666441deviatory
aviator10229662_aviator
decimator1447732decimator
dedicator1348252dedicator
deflator12328342deflator
delator83015022de_lator
depictor1355512depictor
depilator1247652depilator
deviate11312712deviat_e
deviated13311042deviated
deviates12312732deviates
deviation13312392deviation
devisor11357042devi_sor
evictor12346362_evictor
levator10298962lev_ator
levitator1245492levitator
mediator1139042mediator
obviator1344742obviator
viator93211832__viator
aerator7314843ae_rator
alleviator13103303alleviator
aviators11169903_aviators
avigator12236773_avigator
caveator1387233caveator
deaerator10128113deaerator
debater104114693de_bater
debtor938333de__btor
decimators1547503decimators
decorator1248573decorator
dedicators1447743dedicators
dedicatory1745673dedicatory
defeater122611663defeater
defecator1546383defecator
defector14277953defector
deflater123211603deflater
deflators13348153deflators
defoliator1444183defoliator
delators92314823de_lators
delegator1146243delegator
delineator1174173delineator
demeanor1143833demeanor
demister11310223demister
denigrator1245223denigrator
depicter1356853depicter
depictors1465943depictors
depilators1347333depilators
depilatory1645743depilatory
depurator1247023depurator
desiccator1543993desiccator
designator1244713designator
desolator1046673desolator
detector11278323detector
detonator1045983detonator
detractor12147213detractor
devastator1453143devastator
deviance1477083deviance
deviancy1754183deviancy
deviant11311313devia_nt
deviants1236733deviants
deviating14311083deviating
deviations14311163deviations
deviative1647723deviative
deviltry1542983deviltry
deviser114212393devi_ser
devisors12347253devi_sors
devouter1235513devouter
dewater112912423de_water
diatom939453d__iatom
dictator1147263dictator
dilator82712783d_ilator
divinatory1743943divinatory
divisor11345573divi_sor
dominator1258233dominator
donator8310263d_onator
editor738663_edi_tor
educator1147153educator
elevator1146713elev_ator
epilator1049243_epilator
equator1637483_equator
evertor1038723_evertor
evictors13276853_evictors
evocator1346573_evocator
expiator1747043expiator
fellator1176713fellator
genitor837273geni_tor
heritor10310563heri_tor
hesitator1286023hesitator
legator83011133le_gator
levators11249283lev_ators
levitators1345403levitators
mediators1248923mediators
mediatory1546433mediatory
meditator1246593meditator
navigator1364883navigator
negator83010673ne_gator
obviators1444843obviators
radiator949203radiator
relator74016363re_lator
remittor10316553remittor
resistor847673resistor
revelator1286533revelator
revisor10388733revi_sor
senator7313073se_nator
servitor1145063servi_tor
testator847373testator
viators102712023__viators
victor113210673__victor
vitiator1147043vitiator

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621106.32623105.0
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.79526297.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.