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

147 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
deceiver143623(None) 
deceive1337811deceive_
deceived1535891deceived
deceivers1535721deceivers
deceives1437901deceives
receiver1337411receiver
decemvir1641962decemvir
decenter112412162decenter
decider114213182dec_ider
decliner113710842decliner
decrier102713552decri_er
deliver113312242de_liver
depriver1446292depriver
deriver114213912de_river
deserver12118382deserver
perceiver1644552perceiver
receive1239732receive_
received1437982received
receivers1436362receivers
receives1339742receives
believer13448423believer
bereaver1346673bereaver
beshiver1634483beshiver
ceiler84013963__ceiler
conceiver1657413conceiver
decaliter1247983decaliter
decanter112510793decanter
decayer13339353dec_ayer
decease1049523decease_
deceased1247713deceased
deceases11410153deceases
deceit93018213decei__t
deceits102810883decei_ts
deceiving1635733deceiving
decemviri1751363decemviri
decemvirs1741993decemvirs
decenters122410373decenters
decentre11248553decentre
deceptive1746853deceptive_
decerned1237263decerned
deciare10710663dec_iare
decibel1235993dec_ibel
decide104116873dec_ide_
decided124312423dec_ided
deciders123510753dec_iders
decides114217653dec_ides
decile94619213dec_ile_
deciles104417723dec_iles
deciliter1247033deciliter
decipher1644423decipher
decisive1446633decisive_
decker135215993dec__ker
declaimer1444233declaimer
declarer1148063declarer
decline103716613decline_
declined123910883declined
decliners12358613decliners
declines113315803declines
decoder113712293dec_oder
decoyer13348683dec_oyer
decreer10269123dec_reer
decretive1547493decretive_
decried112612853decri_ed
decriers11299733decri_ers
decries103319803decri_es
decurve1335583decurve_
decurved1534843decurved
decurves1435863decurves
deedier93011593de_edier
deeper93613503de_e_per
defeater122611663defeater
defender1337293defender
deferrer12135593deferrer
defier105118653de_fi_er
defiler113911883de_filer
definer114413773de_finer
degender1136893degender
deicer94114413d__eicer
deifier113013123deifi_er
dejeuner1682933dejeuner
deleave1147723deleave_
deleaved1346573deleaved
deleaves1248063deleaves
delivers123310753de_livers
delivery15286553de_livery
delver104913493d__elver
demerger12127373demerger
denier74420693de_ni_er
depraver1435413depraver
deprive1338303deprive_
deprived1546463deprived
deprivers1545213deprivers
deprives1438393deprives
derider93214973de_rider
derive103817043de_rive_
derived123912763de_rived
derivers123811363de_rivers
derives114017813de_rives
dernier83011943derni_er
descender1346663descender
describer1444613describer
descrier1157623descri_er
deserter91211603deserter
deserve11108703deserve_
deserved13108133deserved
deservers13107293deservers
deserves12109893deserves
desilver12286503desilver
desirer8310783de_sirer
despiser1136343despiser
detailer9268673detailer
detainer92910793detainer
detecter11298733detecter
deterger10147593deterger
deterrer9137013deterrer
detester9239683detester
deveined1336673deveined
deviser114212393de_viser
dewier104013463de_wi_er
dicier94416233dic_i_er
dickier143512453dicki_er
dictier103411863dicti_er
diver94827803d___iver
driver104714493d__river
duckier143911793ducki_er
peckier153910523pecki_er
perceive1546973perceive_
perceived1744343perceived
perceivers1743893perceivers
perceives1646313perceives
recenter102715443recenter
reciter94117263rec_iter
recliner103211913recliner
recoiler103210493recoiler
recover124312623rec_over
redeliver1344363redeliver
reiver95318293__reiver
reliever11448683reliever
reserver11119633reserver
reviver134411373re_viver
seceder10329573sece_der
techier1269243techi_er
undeceive1544773undeceive_
undeceived1743993undeceived
undeceives1643863undeceives
vetiver1336103ve_tiver
weever123811443we_e_ver

Search took 9 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.1531167915.0
2DLD Change Limit1461621478.14317949.4
3Display Results1471470.0463195.7
 (SQL Overall)1786911478.34221420.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.