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

113 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
detector1127832(None) 
defector14277951defector
detecter11298731detecter
detectors12278301detectors
defecator1546382defecator
defectors15237882defectors
deflector1555062deflector
depictor1355512depictor
detect94217402detect__
detected12289732detected
detecters12217752detecters
detection121310412detection
detects104011092detect_s
detester9239682detester
detractor12147212detractor
director1147772director
ejector16378602_ejector
elector93313252_elector
erector93513802_erector
rejector17237722rejector
selector1048602selector
attestor845463attestor
bettor83612223bet__tor
bisector1245193bisector
deaerator10128113deaerator
debtor938333d__ebtor
decenter112412163decenter
decor84717573d__ec_or
dedicator1348253dedicator
defeater122611663defeater
defecators1656253defecators
defect124816173defect__
defected15289973defected
defection151610643defection
defects134511523defect_s
deflator12328343deflator
deflectors1654773deflectors
deject164512843deject__
dejecta17376363deject_a
dejected19307593dejected
dejection19178663dejection
dejects17389223deject_s
delator83015023de_lator
delegator1146243delegator
demeanor1143833demeanor
demeton1037683deme_ton
depicter1356853depicter
depictors1465943depictors
desecrator1346003desecrator
deserter91211603deserter
detacher1437543detacher
detecting13259983detecting
detections131410033detections
detective1548103detective
detent73624483detent__
detente83313603detent_e
detentes92712863detentes
detention10169543detention
detents83615153detent_s
deter65028043dete___r
deterger10147593deterger
deterrer9137013deterrer
detest74122843detest__
detested10279623detested
detesters10298303detesters
detests83711743detest_s
deticker1545283deticker
detonator1045983detonator
detractors13147283detractors
deviator1248313deviator
digestor10246553digestor
directer1137583directer
directors1248133directors
directory1545863directory
dissector1245513dissector
doctor938993d__octor
eductor1035863_eductor
effector1644873effector
ejectors17328663_ejectors
electors103013843_electors
electro92810033_electro
enactor938033_enactor
erecter93113393_erecter
erectors103514253_erectors
evertor1038723_evertor
evictor12346363_evictor
exactor1636623_exactor
executor1744833_executor
hector113312653__hector
infector13478843infector
injector17236923injector
lector83514983__lector
meteor84910073mete__or
neglector1253433neglector
objector1943803objector
patentor1046373patentor
prelector1348093prelector
protector13169533protector
reactor93011653re_actor
receptor1256693receptor
rector84019743__rector
redactor1147023redactor
reductor1156433reductor
refectory1746023refectory
reflector1445733reflector
rejecter17258943rejecter
rejectors18247613rejectors
retractor11218513retractor
sector83415923__sector
selectors1148943selectors
stentor739373_stentor
stertor7310083_stertor
vector113212063__vector

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 Limit1461621137.78318779.6
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.98222386.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.