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

304 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
affix183600(None) 
admix1557722admix
aff95537612aff__
affair1234352affair
affine12310502affine
affirm1435522affirm
affixal2043762affixal
affixed2134122affixed
affixer2033912affixer
affixes2035502affixes
afflux1942792afflux
afrit8323172afrit
fix136236102__fix
haffit1538532haffit
infix15337772infix
kaffir16345302kaffir
maffia14327202maffia
raffia12287702raffia
reaffix2042322reaffix
refix155212482refix
suffix1935232suffix
taffia12286902taffia
unfix15429032unfix
waffie15338562waffie
zaffir21395512zaffir
aalii5316123aalii
aboil72217543aboil
abri65522213abri_
abris75722603abris
acid77533393a_cid
acmic11312333acmic
acrid86920103acrid
actin74922553actin
addax1435993addax
adit56443653a_dit
admit8319493admit
admixt1637333admixt
aecia73819283aecia
aegis6316783aegis
aerie54634603aerie
afar76720783a_far
afars85716513afars
affaire1344463affaire
affairs1334163affairs
affect1448903affect
affiant1348433affiant
affiche1844313affiche
affinal1336443affinal
affined1436413affined
affines1339483affines
affirms1534383affirms
affixers2143293affixers
affixial2143593affixial
affixing2264333affixing
afflict1547043afflict
afford1346493afford
affray1534973affray
afire86215913afire
afoot8420113afoot
afore85818603afore
afoul8510193afoul
afraid1049713afraid
afrits9311903afrits
aft66849013a_f_t
after85719793after
again65218113again
aggie73415013aggie
agin56132713a_gin
agio57828453a_gio
agria65517143agria
ahi68040233a_hi_
ahis76135383a_his
ai211288393a__i_
aid49269073a__id
ail37171043a__il
aim57858213a__im
ain37579093a__in
air38058393a__ir
ais39083573a__is
ait38093903a__it
akin86328033a_kin
alcid85817963alcid
alfa77624273alf_a
alfas87219043alfas
algid75415573algid
algin65718763algin
alif76242143a_lif
alifs86121263alifs
alit46155693a_lit
alkie95520033alkie
aloin55227413aloin
amain74922893amain
ambit94223713ambit
ami56646813a_mi_
amia66836903a_mia
amid77036343a_mid
amie66339853a_mie
amin66042253a_min
amir65129753a_mir
amis66445323a_mis
amnia75918643amnia
amnic95516243amnic
amnio75218053amnio
ani37751173a_ni_
anil46437433a_nil
anis45746463a_nis
annex12310883annex
antefix1745053antefix
anti45536363anti_
antic75728863antic
antis55033313antis
anvil82712603anvil
apex137220213a_pex
aphid115515393aphid
aphis105917133aphis
apsis75718293apsis
areic73219393areic
arf67453373arf__
arfs76029963arf_s
argil65116883argil
aria46245423a_ria
arid57642713a_rid
aril45843023a_ril
aroid65428333aroid
arris56824683arris
arsis55722423arsis
asci66519143asci_
asdic83814093asdic
aspic95114733aspic
aspis74618143aspis
astir55517093astir
atria56022333atria
atrip75315743atrip
attic75618353attic
audio62917103audio
audit62527883audit
aulic74420243aulic
auric74521723auric
auris55331523auris
auxin121411913auxin
avail8313883avail
avid88325963a_vid
avoid95516673avoid
await85524493await
awful1178143awful
ax911057783a___x
axil116424453a_xil
axis116127913a_xis
ayin76331743a_yin
azoic162912063azoic
baff124632273baff__
baffed154812173baffed
baffies153612943baffies
baffing164011603baffing
baffle14399873baffle
baffs134718053baff_s
baffy165511923baff_y
befit105222663befit
bemix165011453bemix
biffin14369103biffin
bifid11910703bifid
boffin14359053boffin
buffi136112203buffi_
caff125631673caff__
caffein1535333caffein
caffs135417373caff_s
calix145317343calix
coffin14339813coffin
comix163513193comix
cylix17448623cylix
daff115229683daff__
daffed14429493daffed
daffier1457833daffier
daffily1735133daffily
daffing15369733daffing
daffs125116423daff_s
daffy155510283daff_y
defi86321493defi_
defis96717503defis
eff96128623eff__
effigy1642213effigy
efflux1942003efflux
effs105114033eff_s
elfin84312463elfin
facia103218463facia
fagin9216573fagin
fail74840243_fail
fain75840563_fain
fair76332523_fair
fakir125111493fakir
falx147120783_falx
fanfic1436313fanfic
faqir17548643faqir
faux146519073_faux
fax138143313__fax
fib86344273__fib
fid76847683__fid
fie67152443__fie
fife106027703_fife
fig76242833__fig
fil65447143__fil
fin66458033__fin
fir66744893__fir
fit66365453__fit
fixt1410729713__fixt
fiz156238763__fiz
flax147325633_flax
flex146123473_flex
flic96223733_flic
flip96324263_flip
flir76422203_flir
flit76539273_flit
flux145617743_flux
foil76433913_foil
foin77231563_foin
fox136737863__fox
frig85424503_frig
frit77044473_frit
friz166324343_friz
gaff114828153gaff__
gaffe124111653gaff_e
gaffed144210203gaffed
gaffer134310133gaffer
gaffes134811103gaffes
gaffing15379733gaffing
gaffs124914653gaff_s
haffet15311703haffet
haffits1636193haffits
hafiz20611213hafiz
helix154413013helix
iff96730393iff__
iffier1236763iffier
iffy135312283iff_y
immix1635033immix
kaffirs17325553kaffirs
kafir12488903kafir
kefir12457913kefir
kufi11910653kufi_
kufis1249253kufis
kylix19416323kylix
maffias15327283maffias
maffick2143523maffick
mafia104418033mafia
mafic125615463mafic
maftir1136493maftir
mastix152310503mastix
matrix1539833matrix
mix126138183__mix
muffin14298873muffin
naff105128933naff__
naffed13408333naffed
naffing14359033naffing
naffs116213963naff_s
nix106932833__nix
off96331633off__
offal1136243offal
offed12359163offed
offer114311383offer
office1435693office
offing13368643offing
offish15137273offish
offs107117013off_s
pfft12311883pff_t
pfui9349793pfui_
pix126437933__pix
prefix18356853prefix
puffin141149003puffin
radix134414593radix
raff104933043raff__
raffias13237713raffias
raffish1658843raffish
raffle123910703raffle
raffs115017523raff_s
refit84230063refit
remix145916553remix
six105339743__six
soffit1237873soffit
subfix1835073subfix
taffias13377413taffias
taffies133012693taffies
taffy145110823taff_y
tafia84215493tafia
tiffin12327933tiffin
traffic1544733traffic
unfit84518563unfit
unfixt16398423unfixt
unmix14388973unmix
varix154313503varix
waff134228043waff__
waffed16459793waffed
waffies163611443waffies
waffing173710243waffing
waffle15369183waffle
waffly18305433waffly
waffs146315473waff_s
yaff135324263yaff__
yaffed16457323yaffed
yaffing17337823yaffing
yaffs145311123yaff_s
zaffar21385043zaffar
zaffer21397153zaffer
zaffirs22375663zaffirs
zaffre21354663zaffre
zaftig1933253zaftig

Search took 6 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 Filter178691836670.1431249587.4
2DLD Change Limit836673044.85617229.6
3Display Results3043040.0803800.0
 (SQL Overall)1786913045.07935182.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.