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

163 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
deceived153589(None) 
deceive1337811deceive_
deceiver1436231deceiver
deceives1437901deceives
received1437981received
deceased1247712deceased
deceivers1535722deceivers
decerned1237262decerned
decided124312422dec_ided
declined123910882declined
decried112612852decri_ed
decurved1534842decurved
deleaved1346572deleaved
deprived1546462deprived
derived123912762de_rived
deserved13108132deserved
deveined1336672deveined
perceived1744342perceived
receive1239732receive_
receiver1337412receiver
receives1339742receives
undeceived1743992undeceived
archived17355993archived
becrimed1565513becrimed
believed14427923believed
bereaved1446403bereaved
ceiled94114953__ceiled
conceived1746713conceived
deaired9411533de_aired
deaved114916553d__eaved
debeaked1634613debeaked
debited113311623de_bited
debrided1336583debrided
decamped1634963decamped
decanted122310493decanted
decayed14309333dec_ayed
decease1049523decease_
deceases11410153deceases
deceit93018213decei__t
deceits102810883decei_ts
deceiving1635733deceiving
decemvir1641963decemvir
decenter112412163decenter
decentred13236233decentred
deceptive1746853deceptive_
decibel1235993dec_ibel
decide104116873dec_ide_
decider114213183dec_ider
decides114217653dec_ides
decile94619213dec_ile_
deciles104417723dec_iles
decisive1446633decisive_
decked145217623dec__ked
declaimed1544383declaimed
declared1248743declared
declawed1545923declawed
decline103716613decline_
decliner113710843decliner
declines113315803declines
decocted1437683decocted
decoded123212383dec_oded
decoyed14358333dec_oyed
decreased1345453decreased
decreed112710253dec_reed
decretive1547493decretive_
decrier102713553decri_er
decries103319803decri_es
decupled1494983decupled
decurve1335583decurve_
decurves1435863decurves
deeded94615543de_e_ded
deemed104713063de_e_med
defeated132812163defeated
defected15289973defected
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferred13106363deferred
defied115016383de_fi_ed
defiled124013103de_filed
defined123813823de_fined
degermed1335453degermed
deiced104214483d__eiced
deified123112413deifi_ed
dejected19307593dejected
deleaded1148333deleaded
deleave1147723deleave_
deleaves1248063deleaves
deleted93314903dele_ted
delimed11310723de_limed
deliver113312243de_liver
delved114112753d__elved
demeaned1237283demeaned
demented12311273demented
demerged13157603demerged
demerited1339073demerited
demised113613683de_mised
denied84318633de_ni_ed
denimed1159233de_nimed
dentiled1039743dentiled
depended1337983depended
depermed1436453depermed
depraved1535543depraved
deprive1338303deprive_
depriver1446293depriver
deprives1438393deprives
derailed102410403derailed
derided102914253de_rided
derive103817043de_rive_
deriver114213913de_river
derives114017813de_rives
descended1446283descended
described1544953described
descried1248073descri_ed
deserted101012203deserted
deserve11108703deserve_
deserver12118383deserver
deserves12109893deserves
desexed1636173dese_xed
desired9311983de_sired
despised1236923despised
despited1248323despited
destined103312453destined
detailed10319873detailed
detained103111643detained
detected12289733detected
deterged11127923deterged
deterred10137803deterred
detested10279623detested
develed123611933deve_led
devested13239133devested
deviled124112183de_viled
devised123712563de_vised
devoiced15276063devoiced
devolved16325513devolved
dived106321373d___ived
pectized22257593pectized
peeved124112883pe_e_ved
perceive1546973perceive_
perceiver1644553perceiver
perceives1646313perceives
receded112713043rece_ded
receipted1445333receipted
receivers1436363receivers
recessed1139713recessed
recited104319103rec_ited
reclined113613603reclined
recoiled113613213recoiled
recoined113614423recoined
recurved1436493recurved
reeved104118713re_e_ved
reived104518133__reived
relieved12438513relieved
relived115114683re_lived
reseized1839213reseized
reserved121010583reserved
revived144211653re_vived
reweaved1535953reweaved
scrived134511113_scrived
seceded11319203sece_ded
secerned1136103secerned
undeceive1544773undeceive_
undeceives1643863undeceives

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 Limit1461621637.50019488.3
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.73623098.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.