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

109 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
deceivers153572(None) 
deceiver1436231deceiver_
deceives1437901deceive_s
receivers1436361receivers
deceive1337812deceive__
deceived1535892deceive_d
decemvirs1741992decemvirs
decenters122410372decenters
deciders123510752dec_iders
decliners12358612decliners
decriers11299732decri_ers
delivers123310752de_livers
deprivers1545212deprivers
derivers123811362de_rivers
deservers13107292deservers
perceivers1743892perceivers
receiver1337412receiver_
receives1339742receive_s
believers14346633believers
bereavers1446123bereavers
beshivers1743713beshivers
ceilers93912533__ceilers
clivers123411753__clivers
conceivers1746313conceivers
decaliters1345213decaliters
decanters12229223decanters
decayers14307963dec_ayers
deceases11410153decease_s
deceits102810883decei__ts
deceiving1635733deceiving
decemvir1641963decemvir_
decemviri1751363decemviri
decenter112412163decenter_
decentres12238523decentres
deciares11510633dec_iares
decibels1344523dec_ibels
decider114213183dec_ider_
decides114217653dec_ide_s
deciles104417723dec_ile_s
deciliters1345173deciliters
deciphers1744393deciphers
deckers144413833dec__kers
declaimers1543593declaimers
declarers1236423declarers
decliner113710843decliner_
declines113315803decline_s
decoders122810413dec_oders
decoyers14287713dec_oyers
decreers11277623dec_reers
decrier102713553decri_er_
decries103319803decri_e_s
decurves1435863decurve_s
defeaters13289103defeaters
defenders1436363defenders
deferrers13115153deferrers
defiers113913993de_fi_ers
defilers12439473de_filers
definers124211193de_finers
degenders1236083degenders
deicers103612733d__eicers
deifiers12348993deifi_ers
dejeuners1742443dejeuners
deleaves1248063deleave_s
deliver113312243de_liver_
delivery15286553de_livery
delvers113411993d__elvers
demergers13146403demergers
deniers84515183de_ni_ers
depravers1534683depravers
depriver1446293depriver_
deprives1438393deprive_s
deriders102411853de_riders
deriver114213913de_river_
derives114017813de_rive_s
descenders1445453descenders
describers1543583describers
descriers1245693descri_ers
deserters10129983deserters
deserver12118383deserver_
deserves12109893deserve_s
desilvers13306083desilvers
desirers939263de_sirers
despisers1245153despisers
detailers10257253detailers
detainers10269103detainers
detecters12217753detecters
detergers11147183detergers
deterrers10116593deterrers
detesters10298303detesters
devisers12339863de_visers
divers105024963d___ivers
drivers114412793d__rivers
perceiver1644553perceiver_
perceives1646313perceive_s
receive1239733receive__
received1437983receive_d
reciters102613113rec_iters
recliners11279113recliners
recoilers11318153recoilers
recovers133511123rec_overs
redelivers1443553redelivers
reivers105117083__reivers
relievers12387063relievers
reservers12138103reservers
revivers14389633re_vivers
seceders11277963sece_ders
undeceives1643863undeceive_s
vetivers1435163ve_tivers
weevers13379993we_e_vers

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411097.20320636.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.68923239.8
 
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.