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

255 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
despite1041012(None) 
despise1038681despise
despited1248321despited
despites11410311despites
respite9513031respite
depside1138412depside
depute94512302de_pute
desire7415302des_ire
despised1236932despised
despiser1136342despiser
despises1139432despises
despot93413292despot_
despots10319682despots
destine83719952destine
dispute1039082dispute
hessite1038992hessite
resite64128452res_ite
respire9411542respire
respited11410812respited
respites10513242respites
spite75430662__spite
vespine1237902vespine
andesite949453andes_ite
aspire8612123_aspire
auspice1136523auspice
beside95114613bes_ide
beslime1146833beslime
besmile1137463besmile
bespake15436963bespake
bespoke15468113bespoke
cerite84724873ce_rite
cespitose1342063cespitose
cesspit1145463cesspit_
cesspits1243663cesspits
coesite9713623coes_ite
cuspate1138233cuspate
dacite91115883d_acite
dassie74615573dassi_e
dealate83617843dealate
dearie73319813deari_e
debate94419193de_bate
debit85727853de_bit_
debited113311623de_bited
debits94214503de_bits
debride1138593debride
deceit93018213deceit_
deceits102810883deceits
deceive1337813deceive
decide104116873de_cide
decile94619213de_cile
decline103716613decline
defile105216663de_file
define104718143de_fine
definite1239333definite
deflate113613943deflate
deice84320033de__ice
deicide1149403deicide
deity94316773de__ity
delaine8314793delaine
delate73827753de_late
delete73620703de_lete
delime9314043de_lime
demise94618323de_mise
demit84832303de_mit_
demits94918073de_mits
demote94817803de_mote
dempster1355773dempster
dendrite1048783dendrite
denote74118043de_note
density1137593density
dentate8315153dentate
dentine83320243dentine
depict113514793de_pict
depicted1437743de_picted
depicter1356853de_picter
depicts12358463de_picts
depilate11311703de_pilate
deplete103010423deplete
depone93616553de_pone
depose94215763de_pose
depot85727923de_pot_
depots94716343de_pots
deprive1338303deprive
depsides1238503depsides
depth114311853de_p_th
deputed114610173de_puted
deputes104911783de_putes
deputy12426713de_puty
derate74531233de_rate
deride84420033de_ride
derive103817043de_rive
desalt7518313desalt_
desalted1038313desalted
desalter938363desalter
desalts839573desalts
describe1346243describe
desert72725493desert_
deserted101012203deserted
deserter91211603deserter
deserts82513053deserts
deserve11108703deserve
design8408933des_ign
desired9311983des_ired
desirer8310783des_irer
desires81316133des_ires
desist74818813des_ist
desisted1039783desisted
desists83611723desists
desmid1048363desmi_d
desmids1166603desmids
desolate9411993desolate
despair1045463despair
despaired1344503despaired
despairer1243693despairer
despairs1144943despairs
despatch1643223despatch
desperate12410843desperate
despisal1144673despisal
despisers1245153despisers
despiteful1651733despiteful
despiteous1352323despiteous
despiting13179323despiting
despoil1046523despoil
despoiled1344653despoiled
despoiler1243963despoiler
despoils1145623despoils
despond1137513despond
despotic1346533despotic
despumate1443523despumate
destined103312453destined
destines93619663destines
destiny113111463destiny
destitute1046883destitute
detente83313603detente
deviate11312713deviate
device124512163de_vice
devise104215753de_vise
devoice13347343devoice
devote104513783de_vote
dexie134716893de_xi_e
diorite8314913diorite
dislike122913453dislike
dispose10312763dispose
disprize2048433disprize
disputed1238353disputed
disputer1137973disputer
disputes1139653disputes
disrate81418523disrate
disunite999313disunite
dite55547563d___ite
dumpsite1344293dumpsite
dunite7315013d_unite
dunnite857333dunnite
elite56230183_e_lite
empire1039323_empire
endite73817593_endite
espial839543_espial
espied9359783_espied
espies83716803_espies
esprit8312843_esprit_
esprits938393_esprits
estate64719763_estate
evite85317683_e_vite
excite15310883_excite
expiate16910593_expiate
expire1538023_expire
felsite1039083felsite
ferrite103312753ferrite
festive1339773festive
gestate83614073gestate
geste65920693ges__te
hempie132410563hempi_e
hessites1138613hessites
hospice14117063hospice
inspire938253inspire
jesuit1339583jesuit_
jesuits1436323jesuits
kelpie12308613kelpi_e
kernite1159473kernite
kewpie15465413kewpi_e
lenite6719983le_nite
leucite937753leucite
mesquite19537043mesquite
miscite11314383miscite
muspike1536043muspike
pelite84323003pe_lite
penlite9313243penlite
pepsine11310603pepsine
perlite9317323perlite
perspire1246663perspire
petite84320653pe_tite
psephite1543843psephite
recite83625113re_cite
repine85627813re_pine
repute84716093re_pute
requite162012483requite
reseize1639553reseize
reshine102816943reshine
reside74224933res_ide
resile64627673res_ile
resit54241043res_it_
resited85122423res_ited
resites74027793res_ites
resits64725563res_its
resize154117723res_ize
reslate73520593reslate
respace11310913respace
respade1039573respade
respired1148993respired
respires10311903respires
resplice1237253resplice
resplit9310373resplit_
resplits1037723resplits
respoke134311283respoke
respot83117633respot_
respots92912763respots
restate73824883restate
restive10315933restive
resupine1037543resupine
reunite7312713reunite
rewrite10311143rewrite
sessile739523sessile
sestine73017923sestine
site47052423__s_ite
skite95120063__skite
smite75224873__smite
sopite84917713_sopite
spate74731583__spate
spice95528813__spice
spike114922843__spike
spile75230083__spile
spine76534423__spine
spire75828693__spire
spit65545083__spit_
spited94820443__spited
spites84127333__spites
spits74429553__spits
spitz166017973__spitz
sprite84421773__sprite
suite54829563__suite
suspire937803suspire
tectite9310583tectite
tektite1136883tektite
tergite8311003tergite
termite9313893termite
testate73916233testate
verite94323443ve_rite
vespid1246083vespi_d
vespids1334613vespids
vestige1137433vestige
website1235323website
weepie11258793weepi_e
weskit1338343weskit_
weskits1434743weskits
zeolite1638903zeolite

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272556.04622167.9
3Display Results2552550.0962656.3
 (SQL Overall)1786912556.56227231.2
 
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.