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
aviator10229672aviator
depictor1355512depictor
deviator1248322deviator
editor738662edi_tor
eductor1035862eductor
ejector16378602ejector
elector93313262elector
elicitor1045772elicitor
enactor938042enactor
erector93513812erector
evertor1038722evertor
evict104417142evict__
evicted1337242evicted
evictee1248102evictee
eviction13228682eviction
evicts11368552evict_s
evocator1346572evocator
exactor1636632exactor
excitor1645992excitor
lictor83610862_lictor
vector113212062_vector
viator93211832_viator
victors123311182_victors
victory15326982_victory
actor71116083__actor
aviators11169913aviators
avigator12236773avigator
coactor1139133coactor
dedicator1348253dedicator
defector14277953defector
depicter1356853depicter
depictors1465943depictors
detector11278323detector
deviators1358543deviators
deviatory1666453deviatory
devisor11357043devi_sor
doctor938993_doctor
edict84722283edict__
edictal1046993edictal
edicts94911703edict_s
editors839423edi_tors
educator1147153educator
eductors1135983eductors
effector1644873effector
ejectors17328663ejectors
electors103013863electors
electro92810033electro
elicitors1145803elicitors
emitter93211083emitter
enactors1038463enactors
enactory1346153enactory
epilator1049243epilator
equator1637483equator
erecter93113393erecter
erectors103514263erectors
evacuator14114933evacuator
evection131910833evection
evertors1138953evertors
evictees1344583evictees
evicting1437483evicting
evictions14228623evictions
evildoer1241933evildoer
eviler94811893evi_ler
eviller1056673eviller
evite85317683evi_t_e
evited104013143evi_ted
evites94916473evi_tes
evocators1446713evocators
exacter1637403exacter
exactors1737023exactors
exciter1637753exciter
exciton1646083exciton
excitors1746093excitors
executor1744833executor
expiator1747043expiator
factor11911463_factor
functor1235203functor
genitor837273geni_tor
hector113312653_hector
heritor10310563heri_tor
ichor1039483__ichor
indictor1147463indictor
lector83514993_lector
levator10298963lev_ator
levitator1245493levitator
lictors93212603_lictors
mediator1139043mediator
obviator1344753obviator
predictor1447093predictor
proctor11310433proctor
quittor16285603quittor
reactor93011663reactor
rector84019753_rector
redactor1147033redactor
reductor1156433reductor
rejector17237723rejector
remittor10316553remittor
resistor847673resistor
revisor10388733revi_sor
sector83415933_sector
selector1048623selector
servitor1145063servi_tor
suitor63311053sui_tor
tictoc1036003_tictoc
tractor9311343tractor
vectors123212593_vectors
viators102712023_viators
vicar10513863_vic_ar
victim1337693_victim
victoria1346333_victoria
vigor92612423_vi_gor
visitor1046203_visitor
visor82512833_vi_sor
vizor173010093_vi_zor

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271176.93619323.4
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.38824186.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.