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

143 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
affects153539(None) 
affect1448901affect_
effects1535281effects
advects13276012advects
affected1744792affected
affecter1644522affecter
affecters1763932affecters
afflicts1644002afflicts
afreets1037012afreets
aspects1146742aspects
defects134511522defects
effect1437442effect_
haffets1636052haffe_ts
infects12279712infects
refects124012742refects
abducts1265313abducts
abets75621673a_be_ts
abject17137703abject_
abreacts1245633abreacts
absents93510723absents
accents113511233accents
accepts13356353accepts
acts66929863a___cts
addicts1176013addicts
adducts1174603adducts
adepts9117103a_depts
advect12309123advect_
advents11309473advents
adverts11308513adverts
affairs1334163affairs
affecting1845233affecting
affection1745893affection
affections1845893affections
affective20135413affective
affectless1842133affectless
afferents1546013afferents
affiants1445233affiants
affiche1844313affiche
affiches1945233affiches
affines1339483affines
affirms1534383affirms
affixes2035503affixes
afflatus1442683afflatus
afflict1547043afflict_
affluents15133303affluents
affords1435023affords
afforests1543733afforests
affrays1644063affrays
affronts1444163affronts
afreet9315153afreet_
afrits9311903a_frits
afters94717073afte_rs
agents74816293a_gents
aglets73915683agle_ts
alecs76620733a_lec_s
alerts64418223a_lerts
aments85219803a_ments
analects1047703analects
arecas84817443a_recas
argents84014853argents
armets84918353arme_ts
arpents93613083arpents
arrests73312683arrests
ascents93812553ascents
aspect10612823aspect_
assents74512223assents
asserts74311793asserts
assets65617663asse_ts
attests7278813attests
averts95715243a_verts
avocets1235453avocets
bisects1137133bisects
buffets15317593buffe_ts
caffeins1645123caffeins
cathects1545793cathects
coeffects1942463coeffects
confects153110873confects
defeats113511233defeats
defect124816173defect_
deflects14336733deflects
dejects17389223dejects
detects104011093detects
directs102710263directs
disaffects1992113disaffects
effaces15277273effaces
effected1744993effected
effecter1664773effecter
effecters1764323effecters
effector1644873effector
effectors1755033effectors
effete1235183effe_te
efforts1334703efforts
ejects15409953_ejects
elects83315003_elects
erects84116183_erects
expects1866883expects
exsects1655573exsects
facets116316653face_ts
facts107021893__facts
faeces114713123_faeces
faucets12578443faucets
feats86432753__feats
feces105625363__feces
fecks145417853__fecks
felts85324543__felts
fests85828043__fests
fets75345943__fe_ts
flecks154310803_flecks
fleets96915063_fleets
frets85523403_fre_ts
gabfests1442383gabfests
gaffers14428713gaffe_rs
gaffes134811103gaffe__s
haffet15311703haffe_t_
haffits1636193haff_its
infect113413443infect_
infests10279793infests
inflects1336193inflects
injects16257453injects
insects93710843insects
mafficks2243173mafficks
objects18123693objects
offbeats1682813offbeats
offcuts1542573offcuts
offences1645023offences
offends14234293offends
offers12349963offe_rs
offices1536243offices
offsets1333503offsets
pandects1335843pandects
perfects15107353perfects
praefects1642873praefects
prefects1598133prefects
refect114319333refect_
reflects13288873reflects
rejects163910693rejects
resects94115593resects
sects75622893__sects
selects91912143selects
taffeta1343263taffe_ta
taffetas1442723taffetas
tuffets13266523tuffe_ts
zaffers22386773zaffe_rs

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271435.60623907.8
3Display Results1431430.0463108.7
 (SQL Overall)1786911436.10529269.6
 
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.