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

117 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
devotees1228628(None) 
devotee113811821devotee_
devotes113713751devot_es
demotes104717672demot_es
denotes83817002denot_es
deportees1256642deportees
devisees12358282devisees
devoices14307412devoices
devolves15286262devolves
devote104513782devot_e_
devoted124111092devot_ed
revotes104716392revot_es
bootees94114473_bootees
celotexes1843613celotexes
cenotes92814543cenot_es
debaters113511913debaters
debates103718523debat_es
deboners11268113deboners
debones103315113debo_nes
decoders122810413decoders
decodes113914983deco_des
decoyers14287713decoyers
decrees102513123de_crees
deforces14248403deforces
degrees92810723de_grees
deities82621923de_ities
delates83526283delat_es
deletes83117933delet_es
delouses9310013delouses
demoness1138053demoness
demoses103815823demo_ses
demote94817803demot_e_
demoted114313543demot_ed
demotics1338753demotics
denote74118043denot_e_
denoted93512763denot_ed
departees1265723departees
depletes112810633depletes
depones103717093depo_nes
deportee11510353deportee_
deporters1277793deporters
deposers11359243deposers
deposes103117213depo_ses
depots94716343depot__s
deputes104911783deput_es
deputies1157533deputies
derates84028883derat_es
deters74724683de__ters
detoxes1538803deto_xes
devalues1235853devalues
devels104313903dev__els
deviates12312733deviates
devices133212583dev_ices
devisee113812713devisee_
devisers12339863devisers
devises114116763dev_ises
devoice13347343devoice_
devoiced15276063devoiced
devoirs1175783devo_irs
devolve14316063devolve_
devolved16325513devolved
devons104512253devo__ns
devotedly1742553devotedly
devotedness1653693devotedness
devotement1646283devotement
devotements1745613devotements
devoting1338823devoting
devotion1256763devotion
devotions1356593devotions
devoured1335723devoured
devourer1235063devourer
devourers1344093devourers
devours1166643devo_urs
devouter1235513devouter
devoutest1343643devoutest
devoutness1443103devoutness
dewaters122910713dewaters
dhooties1237633dhooties
divorcees1543333divorcees
divorces1445673divorces
divots104712203divot__s
donees74519493d__onees
doolees83711613d_oolees
doters74423913d__oters
dotes65836693d__ot_es
draftees12225253draftees
emoters94712873_emoters
emotes84620283_emot_es
epopees1137233_epopees
evictees1344583_evictees
evites94916473_evit_es
evokers14386793_evokers
evokes13459683_evo_kes
evolves13286743_evolves
gavottes1274183gavottes
gemotes103712143gemot_es
invitees11377903invitees
legatees9258423legatees
levees93714523lev__ees
levities11310713levities
mentees93214503me_ntees
mestees94617753me_stees
peyotes1238483peyot_es
picotees1247113picotees
remotes94521613remot_es
revoices13278993revoices
revokers15366753revokers
revokes144212503revo_kes
revolters12297483revolters
revolves14278623revolves
revote94917453revot_e_
revoted114314153revot_ed
settees73513633se_ttees
testees74215913te_stees
vestees103513163ve_stees
voters95017443__voters
votes84627083__vot_es

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.1731032896.0
2DLD Change Limit1461621177.17320376.7
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.39224173.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.