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

188 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
affixes203550(None) 
affines1339481affines
affixed2134121affixed
affixer2033911affixer
affixers2143291affixers
admixes1765962admixes
affaires1444302affaires
affiches1945232affiches
affine12310502affine_
affined1436412affined
affirms1534382affirms
affix1836002affix__
affixal2043762affixal
affluxes2142532affluxes
baffies153612942baffi_es
fixes154723592__fixes
infixes17238132infixes
offices1536242offices
reaffixes2243022reaffixes
refixes174813172refixes
suffixes21196352suffixes
taffies133012692taffi_es
unfixes17238112unfixes
waffies163611442waffi_es
abides94719893a_bides
actives12311523actives
addaxes1634573addaxes
admires1038663admires
admixed1833733admixed
advices13136933advices
advises11138973advises
aediles83413903aediles
aegises8311373aegises
aeries64737783aeri_es
affaire1344463affaire_
affairs1334163affairs
affects1535393affects
affiances1745153affiances
affiant1348433affiant
affiants1445233affiants
affiche1844313affiche
affinal1336443affinal
affinely1743863affinely
affirm1435523affi_rm
affirmed1743213affirmed
affirmer1643083affirmer
affirmers1742563affirmers
affixial2143593affixial
affixing2264333affixing
affixment2443883affixment
affixments2543073affixments
affixtures2351783affixtures
afflicts1644003afflicts
affords1435023affords
afforest1446343afforest
affrays1644063affrays
afire86215913a_fire_
afrits9311903afri_ts
aggies83515513aggi_es
agnizes17328843agnizes
aides65336603a__ides
albites9313203albites
alines65735223a_lines
alkies104518093alki_es
alkines114415733alkines
allies63827673alli_es
alpines94016193alpines
alsikes1137263alsikes
amices105018013a_mices
amides95722663a_mides
amies76837693a_mi_es
amines84727983a_mines
ammines11312673ammines
animes84719593a_nimes
anises64826693a_nises
annexes1437203annexes
antefixes1944333antefixes
apexes1539133a_pexes
aphides134711203aphides
apices104916263a_pices
aplites9314933aplites
apomixes1934853apomixes
apsides103911303apsides
arises65233803a_rises
armies85123693armi_es
arrises71617583arrises
arrives101311513arrives
arsines73518813arsines
ascites9312603ascites
asides75118873a_sides
aspires9612043aspires
aspises9611643aspises
assizes1638453assizes
ataxies142410013ataxies
attires72312953attires
audiles83112613audiles
augites8312183augites
axes117337853a___xes
axises134413993a_xises
axites134913833a_xites
azides165113803a_zides
azines155517073a_zines
baffles153710683baff_les
bemixes18338653bemixes
biffies152710853biffi_es
caffeines1743913caffeines
daffier1457833daffi_er
daffiest1537843daffi_est
daffiness1634843daffiness
defies104624053defi_es
defiles114016843defiles
defines114118683defines
effaces15277273effaces
effigies1543513effigies
effluxes2142453effluxes
effuses1335903effuses
facies113921593faci_es
famines123216263famines
faxes155726653__faxes
fices106031163__fices
fifes114822393__fifes
files85441273__files
fines86644263__fines
fires85740753__fires
fives116027363__fives
fixed165416953__fixed
fixer154717833__fixer
fixers165112983__fixers
flaxes165015353_flaxes
flexes164512953_flexes
flies85630713_fli_es
flites95122443_flites
fluxes165212933_fluxes
foxes156321093__foxes
fries85535603_fri_es
friges104116483_friges
frises94124273_frises
frites94922483_frites
frizes184015463_frizes
gaffes134811103gaff__es
haffits1636193haffi_ts
hafizes2235983hafizes
helixes1739133helixes
iffier1236763iffi_er
iffiest1337963iffi_est
iffiness1435023iffiness
immixes1835073immixes
infixed18206563infixed
jiffies20327473jiffi_es
kaffirs17325553kaffi_rs
kaffiyeh2461923kaffiyeh
kaffiyehs2581253kaffiyehs
maffias15327283maffi_as
mafficks2243173mafficks
mastixes1738253mastixes
matrixes1738063matrixes
maxixes1535253maxixes
mixes147224403__mixes
nixes124519623__nixes
office1435693office_
officer1534213officer
officers1643803officers
offings14285833offings
offsides1543393offsides
panmixes1934913panmixes
pixes144323173__pixes
prefixes20389233prefixes
radixes15259343radixes
raffias13237713raffi_as
raffles133611843raff_les
reaffixed2342293reaffixed
refiles104122423refiles
refines105426343refines
refires104820313refires
refixed183611153refixed
remixes164313873remixes
sixes124526363__sixes
subfixes20207493subfixes
suffices16208183suffices
suffixed22214343suffixed
taffias13377413taffi_as
toffies133210213toffi_es
unfixed18218563unfixed
unmixes16197753unmixes
waffie15338563waffi_e_
waffles16329983waff_les
zaffirs22375663zaffi_rs
zaffres22324993zaff_res

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.393454684.5
2DLD Change Limit1340271886.20321606.8
3Display Results1881880.0632984.1
 (SQL Overall)1786911886.65926834.5
 
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.