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

175 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
devotee11381182(None) 
devote104513781devot_e
devoted124111091devoted
devotees12286281devotees
devotes113713751devotes
demote94817802demot_e
demoted114313542demoted
demotes104717672demotes
denote74118042denot_e
denoted93512762denoted
denotes83817002denotes
deportee11510352deportee
devisee113812712devisee
devoice13347342devoice
devolve14316062devolve
devouter1235512devouter
revote94917452revot_e
revoted114314152revoted
revotes104716392revotes
bootee84323023_bootee
celotex1635023celotex
cenote83715843cenot_e
cenotes92814543cenotes
debate94419193debat_e
debated113916083debated
debater104114693debater
debates103718523debates
debited113311623debited
debone93714783debo_ne
deboned113411633deboned
deboner103110483deboner
debones103315113debones
debuted11379333debuted
decocted1437683decocted
decode104414743deco_de
decoded123212383decoded
decoder113712293decoder
decodes113914983decodes
decoyed14358333decoyed
decoyer13348683decoyer
decree93117783de_cree
deforce13267243deforce
defter104215923de_fter
degree82814853de_gree
dehorted1357303dehorted
delate73827753delat_e
delated93722873delated
delates83526283delates
delete73620703delet_e
deleted93314903deleted
deletes83117933deletes
delouse839833delouse
demode104013463demo_de
demoded123611123demoded
demoed103713443demo_ed
demoses103815823demoses
demotic12412333demotic
denotive1238673denotive
dented84120513de_nted
departee1139723departee
deplete103010413deplete
depone93616553depo_ne
deponed113712873deponed
depones103717093depones
deported1249703deported
deportees1256643deportees
deporter1169393deporter
depose94215763depo_se
deposed113412023deposed
deposer104011843deposer
deposes103117213deposes
depot85727923depot__
depots94716343depot_s
depute94512303deput_e
deputed114610173deputed
deputes104911783deputes
derate74531233derat_e
derated93623503derated
derates84028883derates
deter65028043de__ter
detoxed1636103detoxed
detoxes1538803detoxes
devalue1136013devalue
devel94217123dev__el
develed123611933develed
devested13239133devested
deviate11312713deviate
deviated13311043deviated
deviates12312733deviates
device124512163dev_ice
devices133212583devices
deviled124112183deviled
devise104215753dev_ise
devised123712563devised
devisees12358283devisees
deviser114212393deviser
devises114116763devises
devoiced15276063devoiced
devoices14307413devoices
devoid1189353devo_id
devoir1076033devo_ir
devoirs1175783devoirs
devolved16325513devolved
devolves15286263devolves
devon95113683devo__n
devons104512253devo_ns
devotedly1742553devotedly
devotement1646283devotement
devoting1338823devoting
devotion1256763devotion
devour1076703devo_ur
devoured1335723devoured
devourer1235063devourer
devours1166643devours
devout10712993devo_ut
devoutest1343643devoutest
devoutly1542663devoutly
dewater112912423dewater
dexter143810893de_xter
dhootie1136453dhootie
divorce1344813divorce
divorcee1444673divorcee
divot95723073divot__
divots104712203divot_s
donee66931013d__onee
doolee73018953d_oolee
dote55442883d__ot_e
doted75227073d__oted
doter65428623d__oter
dotes65836693d__otes
draftee11379523draftee
emote75421193_emot_e
emoted94614923_emoted
emoter85415193_emoter
emotes84620283_emotes
epopee10312503_epopee
evictee1248103_evictee
evite85317683_evit_e
evited104013143_evited
evites94916473_evites
evoke12478853_evo_ke
evoked14457883_evoked
evoker13467913_evoker
evokes13459683_evokes
evolve12306503_evolve
gavotte1174603gavotte
gemote94613023gemot_e
gemotes103712143gemotes
invitee103713543invitee
legatee82814633legatee
levee84023813lev__ee
mentee84121293me_ntee
mestee84523883me_stee
peyote1139853peyot_e
peyotes1238483peyotes
picotee11311473picotee
pivoted1336513pivoted
remote84222603remot_e
remoter94815973remoter
remotes94521613remotes
revoice12319183revoice
revoke135216243revo_ke
revoked154410523revoked
revoker14419193revoker
revokes144212503revokes
revolted12319863revolted
revolter11279363revolter
revolve13328373revolve
settee63721023se_ttee
testee64323303te_stee
vestee94319153ve_stee
vote74728623__vot_e
voted93919143__voted
voter85121053__voter
votes84627083__votes

Search took 10 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.1401276364.3
2DLD Change Limit1340271759.01614865.5
3Display Results1751750.0632777.8
 (SQL Overall)1786911759.21919382.9
 
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.