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

67 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
objecting214405(None) 
dejecting20217792dejecting
ejecting18268162_ejecting
injecting1997692injecting
objectify2651992objectify
objection2045092objection
objections2145632objections
objective2345372objective
obtesting1245882obtesting
obverting1536302obverting
rejecting192211152rejecting
reobjecting2343032reobjecting
subjecting2245552subjecting
abducting1584083abducting
abetting1158293ab_etting
abjection2045323abjection
abjections2145673abjections
abreacting1544533abreacting
absenting1236993absenting
advecting1645113advecting
affecting1845233affecting
beating104326873_b_eating
becking164416073_b_ecking
belting104119133_b_elting
besting104923923_b_esting
betting103921403_b_etting
bisecting1436973bisecting
bleating113514503_bleating
coerecting15218783coerecting
collecting1548283collecting
confecting18310553confecting
connecting15310383connecting
convecting18310433convecting
correcting15199303correcting
defecting162510223defecting
detecting13259983detecting
directing1338823directing
disjecting2177243disjecting
effecting1845583effecting
electing112113783_electing
erecting112415063_erecting
expecting2146693expecting
exsecting1935933exsecting
infecting15109673infecting
jesting154317713__jesting
jetting153815343__jetting
obeying1336543ob_e_ying
object17135803object___
objected2043493object_ed
objectifying3051693objectifying
objectives2444533objectives
objector1943803object_or
objectors2044053objectors
objects18123693object__s
obsecrating1644133obsecrating
observing1544393observing
obsessing1244263obsessing
obviating1545053obviating
orienting1038723orienting
outacting1239213outacting
outeating10814493outeating
projecting22177243projecting
reejecting2045813reejecting
refecting152413353refecting
resecting122816483resecting
selecting12310533selecting
trajecting2044293trajecting

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 Filter1786911486410.420425454.8
2DLD Change Limit148641676.53322752.3
3Display Results67670.0302233.3
 (SQL Overall)178691676.98325589.4
 
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.