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

171 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
directed123823(None) 
directer1137581directer
bisected1336202bisected
codirected1653002codirected
defected15289972defected
dejected19307592dejected
detected12289732detected
dieted83115492di_e_ted
digested11208162digested
direct93817332direct__
directest1246302directest
directly1455302directly
director1147782director
directs102710262direct_s
disjected2086352disjected
dissected13108662dissected
diverted13199582diverted
divested13268212divested
erected103213992_erected
redirected1444772redirected
undirected1445022undirected
abreacted1444293abreacted
advected1534533advected
affected1744793affected
airted74214503air__ted
arrested939153arrested
birched15349913bir_ched
bracted12410933_bracted
circled1237583cir_cled
coerected1447643coerected
corrected1438113corrected
created104323453_created
crested103416533_crested
curetted1137173curetted
darted84620923dar__ted
decked145217623d__ecked
decocted1437683decocted
deducted1356243deducted
defeated132812163defeated
defecated1637493defecated
deflected1635983deflected
deleted93314913dele_ted
demented12311273demented
dented84120513d__ented
depicted1437743depicted
deprecated1646673deprecated
derated93623503der_ated
deratted1048403deratted
deserted101012203deserted
detecter11298733detecter
detested10279623detested
detracted1357793detracted
devested13239133devested
diced95824683di__c_ed
dicked144920863di__cked
dictated1239203dictated
diester83013683di_ester
dieter73516773di_e_ter
diffracted2042973diffracted
digester10258433digester
dighted132511493di_ghted
digressed1245613digressed
dilated93115823di_lated
diluted9248933di_luted
dimeter10411893dime_ter
dinette8310013dinette_
dinettes9310193dinettes
dinted84419843di__nted
dioecies1138933dioecies
dipnetted1343353dipnetted
directing1338823directing
direction1289783direction
directive1557773directive
directives1655833directives
directness1344193directness
directors1248143directors
directory1545883directory
directress1343103directress
directrix1952423directrix
direst75024243direst__
dirked124912273dir__ked
dirled84514903dir__led
dirtied93210853dir_tied
disced104914653di_sc_ed
discepted1547523discepted
discoed11312483di_scoed
diseased103011713diseased
disputed1238353disputed
disrated10915573disrated
disrelated1247343disrelated
disrooted1147623disrooted
disrupted1345973disrupted
disseated11711083disseated
dissented1199723dissented
disserted11109813disserted
distracted1448873distracted
districted1448223districted
ditched143711903di_tched
diverged14256883diverged
diverter12238623diverter
dizened18267333dize_ned
drafted12439033d_rafted
dratted9358593d_ratted
dreaded103612023d_readed
dreamed114310633d_reamed
dredged11346893d_redged
dreed75222843d_re__ed
drenched15247913d_renched
dressed93511873d_ressed
drifted12367953d_rifted
ducted104012123d__ucted
dueted84113593d_ue_ted
duetted937023d_uetted
effected1744993effected
ejected17297653_ejected
elected102812613_elected
erecter93113393_erecter
eructed10228653_eructed
expected2036743expected
exsected1835673exsected
fileted1159093file_ted
fireweed1545353fireweed
forested12312463forested
fracted1339373_fracted
fretted113411853_fretted
girted83912873gir__ted
greeted93111383_greeted
ideated9310973_ideated
infected14229403infected
injected18226753injected
invected14258883invected
lineated9711063lineated
misacted1338673misacted
misdirected1752463misdirected
nondirected1552953nondirected
objected2043493objected
obtected1344553obtected
oriented937483oriented
parented11912213parented
perfected1736643perfected
pieced113912103pi_ec_ed
pierced12347593pierc_ed
pileated112711133pileated
pipetted1335263pipetted
pirated102515613pir_ated
preacted132710943_preacted
precited133013813_precited
priested1138393priested
reacted103015713__reacted
recited104319103__recited
recked134821803__recked
reerected1238613reerected
refected142311663refected
rejected182710113rejected
rented74426593__rented
rerented92516163rerented
resected112514743resected
rested74430783__rested
retted74826313__retted
riveted11258573rive_ted
rivetted12226093rivetted
selected1159783selected
threated1259203threated
tierced10347053tierc_ed
tincted1037273ti_ncted
treated83618703_treated
trisected1244913trisected
unrented92413923unrented
unrested91914513unrested
wrecked17418333_wrecked
wrested113410933_wrested

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 Filter1786911461620.533335255.2
2DLD Change Limit1461621718.85616504.3
3Display Results1711710.0632714.3
 (SQL Overall)1786911719.45218905.1
 
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.