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

85 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
obtected134455(None) 
objected2043491objected
obtested1135451obtested
detected12289732detected
obtect10129632obtect__
obverted1435102obverted
outacted1139382outacted
abducted1444093abducted
abetted1058333ab_etted
abreacted1444303abreacted
absented1156623absented
advected1534543advected
affected1744803affected
attested936313attested
becked155417763_b_ecked
belted94020633_b_elted
bested94922763_b_ested
betted94721163_b_etted
bisected1336203bisected
bleated104015973_bleated
botched153611903bot_ched
bracted12410933_bracted
cathected1744543cathected
coerected1447643coerected
collected1447973collected
confected1739073confected
connected1438753connected
contacted14139103contacted
contented12313043contented
contested12310703contested
convected1738783convected
corrected1438123corrected
defected15289973defected
dejected19307593dejected
detecter11298733detecter
detested10279623detested
directed1238233directed
effected1744993effected
ejected17297653_ejected
elected102812613_elected
erected103213993_erected
expected2036743expected
exsected1835673exsected
infected14229403infected
injected18226753injected
invected14258883invected
obeyed1235823ob_e_yed
object17135803object__
objector1943803objector
objects18123693object_s
obsecrated1543733obsecrated
observed1444383observed
obsessed1144273obsessed
obstructed1544233obstructed
obtained1136533obtained
obtest81213013obtest__
obtests9136233obtest_s
obtruded1243363obtruded
obtunded1243523obtunded
obturated1245953obturated
obviated1444573obviated
octette946423octette_
octettes1045533octettes
oriented937483oriented
outdated1012513193outdated
outeaten8310423outeaten
outechoed1544633outechoed
outrated92219323outrated
outvoted1237273outvoted
patented1188893patented
protected14158653protected
refected142311663refected
rejected182710113rejected
reobjected2242253reobjected
resected112514743resected
retested92212533retested
selected1159783selected
stetted82610403_stetted
subjected2144773subjected
teated74924023__teated
teched124014433__teched
tented74221003__tented
tested74421523__tested
untented92613413untented
untested92612423untested

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 Filter1786911461620.436409841.7
2DLD Change Limit146162857.23620199.3
3Display Results85850.0461847.8
 (SQL Overall)178691857.71823152.5
 
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.