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

131 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
affixed213412(None) 
affined1436411affined
affixer2033911affixer
affixes2035501affixes
admixed1833732admixed
affine12310502affine_
affines1339482affines
affirmed1743212affirmed
affix1836002affix__
affixal2043762affixal
affixers2143292affixers
fixed165416952__fixed
infixed18206562infixed
reaffixed2342292reaffixed
refixed183611152refixed
suffixed22214342suffixed
unfixed18218562unfixed
abided105313313a_bided
admired1135703admired
admixes1765963admixes
advised12136043advised
aeried74221863aeri_ed
afeared1176833afeared
affaire1344463affaire_
affaires1444303affaires
affected1744793affected
affianced1843033affianced
affiant1348433affiant
affiche1844313affiche
affiches1945233affiches
affinal1336443affinal
affinely1743863affinely
affirm1435523affi_rm
affirmer1643083affirmer
affirms1534383affirms
affixial2143593affixial
affixing2264333affixing
affixment2443883affixment
afflicted1843433afflicted
affluxes2142533affluxes
afford1346493aff_ord
afforded1643433afforded
affrayed1842843affrayed
afield1035953a_field
afire86215913a_fire_
agnized18247223agnized
aided75828933a__ided
ailed66240283a__iled
aimed85626053a__imed
aired66032923a__ired
alined75221403a_lined
aliped95414283a_liped
allied74217153alli_ed
annexed1535753annexed
antired82316193antired
anviled1138953anviled
ariled75620323a_riled
arrived11127353arrived
aspired1068173aspired
attired8238913attired
audited939033audited
availed1135973availed
avoided1235553avoided
awaited1146963awaited
axed128829613a___xed
axised14438963a_xised
baffed154812173baff__ed
baffies153612943baffi_es
baffled16418063baff_led
basifixed2242603basifixed
bemixed19337053bemixed
coffined1735993coffined
daffed14429493daff__ed
daffier1457833daffi_er
defied115016383defi_ed
defiled124013103defiled
defined123813823defined
effaced16225573effaced
effused1434143effused
failed105421603_failed
faired105915773_faired
faxed166220533__faxed
fifed125115973__fifed
filed95331903__filed
fined94930503__fined
fired94829743__fired
fixer154717833__fixer
fixes154723593__fixes
flexed17419093_flexed
flied96519433_fli_ed
flited104616583_flited
fluxed17509673_fluxed
foiled104618403_foiled
foined105915013_foined
foxed165115213__foxed
fried95322913_fri_ed
frized193510683_frized
gaffed144210203gaff__ed
iffier1236763iffi_er
immixed1933573immixed
infixes17238133infixes
kaffiyeh2461923kaffiyeh
mafficked2442243mafficked
mixed155717253__mixed
naffed13408333naff__ed
nixed135714223__nixed
offed12359163off__ed
offered1436143offered
office1435693office_
officer1534213officer
offices1536243offices
prefixed21357703prefixed
raffled14429083raff_led
reaffixes2243023reaffixes
refiled114318653refiled
refined114720003refined
refired115116993refired
refixes174813173refixes
remixed173510743remixed
sufficed17205663sufficed
suffixes21196353suffixes
taffies133012693taffi_es
tiffined1543403tiffined
unfired112212453unfired
unfixes17238113unfixes
unmixed17228213unmixed
waffed16459793waff__ed
waffie15338563waffi_e_
waffies163611443waffi_es
waffled17357523waff_led
yaffed16457323yaff__ed

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.406440125.6
2DLD Change Limit1340271315.58024019.2
3Display Results1311310.0462847.8
 (SQL Overall)1786911316.03229623.8
 
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.