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 “objector” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
objector194380(None) 
objectors2044051objectors
ejector16378602_ejector
injector17236932injector
object17135802object__
objected2043492objected
objection2045092objection
objects18123692object_s
rejector17237722rejector
abductor1343563abductor
abettor956193ab_ettor
abject17137703abject__
abjection2045323abjection
abjectly2242413abjectly
bettor83612223_b_ettor
bisector1245193bisector
collector1346393collector
connector1347923connector
convector1648083convector
corrector1347603corrector
defector14277953defector
detector11278323detector
director1147783director
effector1644873effector
ejectors17328663_ejectors
elector93313263_elector
erector93513813_erector
hector113312653__hector
infector13478853infector
injectors18216723injectors
lector83514993__lector
nonvector1445793nonvector
obento837893ob_ento_
obentos936703ob_entos
objectify2651993objectify
objecting2144053objecting
objections2145633objections
objective2345373objective
objet141213143obje_t__
objets15125323obje_t_s
obsessor1043033obsessor
obtect10129633obtect__
obtected1344553obtected
obviator1344753obviator
projector20186683projector
rector84019753__rector
rejecter17258943rejecter
rejectors18247613rejectors
sector83415933__sector
selector1048623selector
subsector1344403subsector
vector113212063__vector

Search took 7 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.420425454.8
2DLD Change Limit146162526.53322372.9
3Display Results52520.0134000.0
 (SQL Overall)178691526.96625651.9
 
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.