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

117 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
evictor1234636(None) 
evictors13276851evictors
victor113210671_victor
aviator10229662aviator
depictor1355512depictor
deviator1248312deviator
editor738662edi_tor
eductor1035862eductor
ejector16378602ejector
elector93313252elector
elicitor1045772elicitor
enactor938032enactor
erector93513802erector
evertor1038722evertor
evict104417142evict__
evicted1337242evicted
evictee1248102evictee
eviction13228682eviction
evicts11368552evict_s
evocator1346572evocator
exactor1636622exactor
excitor1645992excitor
lictor83610852_lictor
vector113212062_vector
viator93211832_viator
victors123311172_victors
victory15326982_victory
actor71116073__actor
aviators11169903aviators
avigator12236763avigator
coactor1139113coactor
dedicator1348253dedicator
defector14277953defector
depicter1356853depicter
depictors1465943depictors
detector11278323detector
deviators1358533deviators
deviatory1666443deviatory
devisor11357043devi_sor
doctor938993_doctor
edict84722283edict__
edictal1046993edictal
edicts94911703edict_s
editors839423edi_tors
educator1147153educator
eductors1135983eductors
effector1644873effector
ejectors17328663ejectors
electors103013843electors
electro92810033electro
elicitors1145803elicitors
emitter93211083emitter
enactors1038443enactors
enactory1346143enactory
epilator1049243epilator
equator1637483equator
erecter93113393erecter
erectors103514253erectors
evacuator14114933evacuator
evection131910833evection
evertors1138953evertors
evictees1344583evictees
evicting1437483evicting
evictions14228623evictions
evildoer1241933evildoer
eviler94811893evi_ler
eviller1056673eviller
evite85317683evi_t_e
evited104013143evi_ted
evites94916473evi_tes
evocators1446693evocators
exacter1637403exacter
exactors1737013exactors
exciter1637753exciter
exciton1646083exciton
excitors1746093excitors
executor1744833executor
expiator1747043expiator
factor11911453_factor
functor1235203functor
genitor837273geni_tor
hector113312653_hector
heritor10310563heri_tor
ichor1039473__ichor
indictor1147453indictor
lector83514983_lector
levator10298963lev_ator
levitator1245493levitator
lictors93212583_lictors
mediator1139043mediator
obviator1344743obviator
predictor1447093predictor
proctor11310433proctor
quittor16285603quittor
reactor93011653reactor
rector84019743_rector
redactor1147023redactor
reductor1156433reductor
rejector17237723rejector
remittor10316553remittor
resistor847673resistor
revisor10388733revi_sor
sector83415923_sector
selector1048603selector
servitor1145053servi_tor
suitor63311053sui_tor
tictoc1036003_tictoc
tractor9311333tractor
vectors123212593_vectors
viators102712013_viators
vicar10513863_vic_ar
victim1337683_victim
victoria1346313_victoria
vigor92612423_vi_gor
visitor1046203_visitor
visor82512833_vi_sor
vizor173010093_vi_zor

Search took 10 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.1561145455.1
2DLD Change Limit1340271178.86015127.2
3Display Results1171170.0462543.5
 (SQL Overall)1786911179.06219718.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.