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

228 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
maffia1432720(None) 
maffias15327281maffias
mafia104418031ma_fia
raffia12287701raffia
taffia12286901taffia
affix1836002_affix
haffit1538532haffit
kaffir16345302kaffir
maffick2143522maffick
mafias113913572ma_fias
mafic125615462ma_fic
maftir1136492maftir
mania75634142ma_nia
maria75032882ma_ria
muffin14298872muffin
raffias13237712raffias
taffias13377412taffias
tafia84215492ta_fia
waffie15338562waffie
zaffir21395512zaffir
aecia73819283_aecia
aff95537613_aff__
affair1234353_affair
affiant1348433_affiant
affinal1336443_affinal
affine12310503_affine
affirm1435523_affirm
affixal2043763_affixal
affray1534973_affray
afrit8323173_afrit
agria65517143_agria
alfa77624273_alf_a
amia66836893_a_mia
amnia75918633_amnia
amusia839173amusia
aria46245423_a_ria
atria56022333_atria
baff124632263baff__
baffed154812173baffed
baffies153612943baffies
baffing164011603baffing
baffle14399873baffle
baffs134718053baff_s
baffy165511923baff_y
biffin14369103biffin
boffin14359053boffin
buffi136112203buffi_
caff125631673caff__
caffein1535333caffein
caffs135417373caff_s
cambia124913143cambia
cardia9916373cardia
cassia83714763cassia
coffin14339813coffin
daff115229683daff__
daffed14429493daffed
daffier1457833daffier
daffily1735133daffily
daffing15369733daffing
daffs125116423daff_s
daffy155510283daff_y
dahlia1035773dahlia
facia103218463fa_cia
fanfic1436313fanfic
fascia1148703fascia
gaff114828153gaff__
gaffe124111653gaff_e
gaffed144210203gaffed
gaffer134310133gaffer
gaffes134811103gaffes
gaffing15379733gaffing
gaffs124914653gaff_s
gambia115912233gambia
haffet15311703haffet
haffits1636193haffits
hafiz20611213ha_fiz
kaffirs17325553kaffirs
kaffiyah2491573kaffiyah
kafir12488903ka_fir
kalmia1238893kalmia
labia75219003la_bia
lamia75324323la_mia
latria62313583latria
luffa11409023luff_a
macchia1645883macchia
macula103013673macula
madeira1045103madeira
mafficks2243173mafficks
maftirs1236043maftirs
magi76329523ma_gi_
magian9312833ma_gian
magic105818653ma_gic
magma104513573ma_gma
magpie1139093magpie
mahonia1238443mahonia
maid75537633ma__id
mail65543433ma__il
maim85831473ma__im
main65345503ma__in
mair66133763ma__ir
makuta1236393makuta
malaria9313693malaria
malefic1486323malefic
malfed12369753malfed
malic94525653ma_lic
malkin122913143malkin
maltha1137503maltha
mama86231583ma__ma
mamba116317513ma_mba
mamie95826003ma_mie
mamma86317913ma_mma
mammie94313783mammie
mana65341943ma__na
manana84816073manana
manful11610213manful
manga85026193ma_nga
maniac103917973ma_niac
manias84029033ma_nias
manic94629433ma_nic
manila84518303manila
manna75522533ma_nna
manta75629903ma_nta
mantic104120903mantic
mantid93820373mantid
mantis83926033mantis
mantra84116093mantra
mantua84412023mantua
maqui16249953maqui_
maquila1844703maquila
maquis17249483maquis
mara67444563ma__ra
maraca10314153maraca
margin94016843margin
marina84623413marina
marka114620793ma_rka
markka11416593markka
marlin84220903marlin
martial92415413martial
martian93514683martian
martin84122523martin
masa65034713ma__sa
masala8311813masala
mashie11315933mashie
masjid16187313masjid
massa75518923ma_ssa
massif11412533massif
mastic103119173mastic
mastix152310503mastix
matin75132853ma_tin
matrix1539833matrix
mattin84416633mattin
matza16311813ma_tza
mavie104722563ma_vie
mavin105722953ma_vin
mavis105622723ma_vis
maxi137023553ma_xi_
maxim165216003ma_xim
maxima17568633maxima
maxis145721563ma_xis
maya95824583ma__ya
mayfly1734403mayfly
mayvin1436523mayvin
mazuma1935603mazuma
media84721713m_edia
miff125625043miff__
miffed15398713miffed
miffier1537023miffier
miffing16298403miffing
miffs134512873miff_s
miffy163910193miff_y
milia72719563m_ilia
misfit112813833misfit
muff124723853muff__
muffed154210593muffed
muffing163210403muffing
muffins15308343muffins
muffle14339643muffle
muffs134114213muff_s
mufti10610543mufti_
muftis1158053muftis
myalgia13124283myalgia
myopia13318433myopia
naff105128933naff__
naffed13408333naffed
naffing14359033naffing
naffs116213963naff_s
nakfa1236093nakf_a
pallia83015593pallia
puffin141149003puffin
raff104933043raff__
raffish1658843raffish
raffle123910703raffle
raffs115017523raff_s
raia46638383ra__ia
raphia113511263raphia
ratafia1045773ratafia
reaffix2042323reaffix
ruffian1344133ruffian
salvia93310753salvia
soffit1237873soffit
suffix1935233suffix
taenia6313193taenia
taffeta1343263taffeta
taffies133012693taffies
taffy145110823taff_y
tafias93111963ta_fias
tarsia65514273tarsia
tiffin12327933tiffin
traffic1544733traffic
varia85824203va_ria
waff134228043waff__
waffed16459793waffed
waffies163611443waffies
waffing173710243waffing
waffle15369183waffle
waffly18305433waffly
waffs146315473waff_s
yaff135324263yaff__
yaffed16457323yaffed
yaffing17337823yaffing
yaffs145311123yaff_s
yautia937243yautia
zaffar21385043zaffar
zaffer21397153zaffer
zaffirs22375663zaffirs
zaffre21354663zaffre
zaftig1933253zaftig
zamia165115213za_mia

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 Filter1786911127160.233766914.2
2DLD Change Limit1127162288.59613112.6
3Display Results2282280.0763000.0
 (SQL Overall)1786912288.90520066.4
 
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.