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 “deviators” 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
deviators135853(None) 
deviator1248311deviator_
deviatory1666441deviatory
aviators11169902_aviators
decimators1547502decimators
dedicators1447742dedicators
deflators13348152deflators
delators92314822de_lators
depictors1465942depictors
depilators1347332depilators
deviates12312732deviat_es
deviations14311162deviations
devisors12347252devi_sors
evictors13276852_evictors
levators11249282lev_ators
levitators1345402levitators
mediators1248922mediators
obviators1444842obviators
viators102712022__viators
aerators8315613ae_rators
alleviators14103173alleviators
aviator10229663_aviator_
avigators13177093_avigators
caveators1497263caveators
deaerators11107713deaerators
debaters113511923de_baters
debtors1038533de__btors
decimator1447733decimator_
decorators1347873decorators
dedicator1348253dedicator_
dedicatory1745673dedicatory
defeaters13289103defeaters
defecators1656253defecators
defectors15237883defectors
deflaters13298703deflaters
deflator12328343deflator_
defoliators1543723defoliators
delator83015023de_lator_
delegators1245633delegators
delineators1253963delineators
demeanors1243743demeanors
demisters1249203demisters
denigrators1344523denigrators
depicters1435823depicters
depictor1355513depictor_
depilator1247653depilator_
depilatory1645743depilatory
depurators1346483depurators
desiccators1643803desiccators
designators1344303designators
desolators1146283desolators
detectors12278303detectors
detonators1145853detonators
detractors13147293detractors
devastators1552923devastators
deviances1566493deviances
deviants1236733devia_nts
deviate11312713deviat__e
deviated13311043deviat_ed
deviating14311083deviating
deviation13312393deviation
deviative1647723deviative
deviltry1542983devilt_ry
devious1138523devi__ous
devisers12339863devi_sers
devisor11357043devi_sor_
dewaters122910723de_waters
diatoms1039073d__iatoms
dictators1247363dictators
dilators93213193d_ilators
divinatory1743943divinatory
divisors12255693divi_sors
dominators1397483dominators
donators9310403d_onators
editors839423_edi_tors
educators1246993educators
elevators1246303elev_ators
epilators1149433_epilators
equators1737473_equators
evertors1138953_evertors
evictor12346363_evictor_
evocators1446713_evocators
expiators1846803expiators
fellators1247143fellators
genitors937423geni_tors
heritors11310903heri_tors
hesitators1385853hesitators
legators92811033le_gators
levator10298963lev_ator_
levatores12225733lev_atores
levitator1245493levitator_
mediator1139043mediator_
mediatory1546433mediatory
meditators1346263meditators
navigators1464823navigators
negators92411173ne_gators
obviator1344743obviator_
radiators1049323radiators
relators83316123re_lators
remittors11256283remittors
resistors947993resistors
revelators13116423revelators
revisors11379063revi_sors
senators8312953se_nators
servitors1245213servi_tors
testators947333testators
viator93211833__viator_
viatores11257683__viatores
victors123311183__victors
vitiators1246923vitiators

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411106.18624028.6
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.65526850.6
 
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.