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

189 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
deceive133781(None) 
deceived1535891deceived
deceiver1436231deceiver
deceives1437901deceives
receive1239731receive
decease1049522decease
deceit93018212decei_t
deceits102810882deceits
deceivers1535722deceivers
deceptive1746852deceptive
decide104116872dec_ide
decile94619212dec_ile
decisive1446632decisive
decline103716612decline
decretive1547492decretive
decurve1335582decurve
deleave1147722deleave
deprive1338302deprive
derive103817042de_rive
deserve11108702deserve
perceive1546972perceive
received1437982received
receiver1337412receiver
receives1339742receives
undeceive1544772undeceive
active11313743_active
adjective2244813adjective
advective1845233advective
archive154610483archive
becrime1387053becrime
beehive1554033beehive
believe12519773believe
belive115415303be_live
bereave1258353bereave
chive135117623__chive
conceive1539233conceive
dacite91115883dac_ite
dative10311813d_ative
dearie73319813deari_e
deave95022333d__eave
debride1138593debride
decade104216163dec_ade
decane93818873dec_ane
decare93919153dec_are
deceased1247713deceased
deceases11410153deceases
deceivable1845023deceivable
deceiving1635733deceiving
decemvir1641963decemvir
decency1537453decency
decent94023703dece_nt
decenter112412163decenter
decentre11248553decentre
decern91310953dece_rn
decerned1237263decerned
decerns10119053decerns
deciare10710663deciare
decibel1235993dec_ibel
decided124312423dec_ided
decider114213183dec_ider
decides114217653dec_ides
deciles104417723dec_iles
decking153915593decking
deckle1312012453dec_kle
declare10411223declare
declined123910883declined
decliner113710843decliner
declines113315803declines
decoctive1745863decoctive
decode104414743dec_ode
decrease1136563decrease
decree93117783dec_ree
decrial10310323decrial
decried112612853decried
decrier102713553decrier
decries103319803decries
decuple1285363decuple
decurved1534843decurved
decurves1435863decurves
deductive1645473deductive
defective1848003defective
defence1339893defence
defense1137503defense
defensive1644993defensive
defile105216663de_file
define104718143de_fine
deice84320033d__eice
deicide1149403deicide
dekeing13358353dekeing
delaine8314793delaine
deleaved1346573deleaved
deleaves1248063deleaves
deleing93313953deleing
delete73620703dele_te
delime9314043de_lime
deliver113312243de_liver
delusive1245843delusive
delve96018263d__elve
demerge11168023demerge
demesne1035573demesne
demise94618323de_mise
denotive1238673denotive
dentine83320243dentine
depletive1545623depletive
deprave1337073deprave
deprived1546463deprived
depriver1446293depriver
deprives1438393deprives
depside1138403depside
deride84420033de_ride
derisive1247503derisive
derived123912763de_rived
deriver114213913de_river
derives114017813de_rives
describe1346243describe
deserved13108133deserved
deserver12118383deserver
deserves12109893deserves
desire7415303de_sire
despise1038683despise
despite10410123despite
destine83719953destine
detective1548103detective
detente83313603detente
deterge9118463deterge
detersive1346343detersive
devein1039143devei_n
deveined1336673deveined
deveins1138803deveins
device124512163de_vice
devise104215753de_vise
devoice13347343devoice
devolve14316063devolve
dexie134716893de_xi_e
dickie133913113dicki_e
directive1557773directive
dive85634773d___ive
docile94213123doc_ile
drive95318003d__rive
duckie133511663ducki_e
ductile1048483ductile
eductive1476863eductive
ejective2037153ejective
elective13311003elective
endive103310473_endive
erective13311833erective
festive1339773festive
fictive1537023fictive
ideative1238573ideative
keeve124512133ke_e_ve
orective1339353orective
pectize20259913pectize
peeve104915253pe_e_ve
pensive122610393pensive
perceived1744353perceived
perceiver1644553perceiver
perceives1646313perceives
reactive13310473reactive
recede95515533rece_de
receipt1159253receipt
receivers1436363receivers
receptive1648323receptive
recessive1447263recessive
recipe103414893rec_ipe
recite83625113rec_ite
recline94020493recline
recurve1237403recurve
redrive112410563redrive
reeve84121323re_e_ve
regive104814323re_give
reive85522943__reive
releve95116403rele_ve
relieve105010693relieve
relive95120783re_live
reseize1639553reseize
reserve101011203reserve
restive10315933restive
revive124914823re_vive
reweave1336773reweave
scrive115414943_scrive
secede93311993sece_de
secretive1446933secretive
sectile9311973sectile
techie11511723techi_e
tectite9310583tectite
tensive10269913tensive
undeceived1743993undeceived
undeceives1643863undeceives
vegetive1545543vegetive

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.406440125.6
2DLD Change Limit1340271895.95322514.2
3Display Results1891890.0802362.5
 (SQL Overall)1786911896.43927751.4
 
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.