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

282 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
maxima1756863(None) 
maxim165216001maxim_
maximal18347091maximal
maxims17399671maxims
anima74620072_anima
mafia104418032mafi_a
magma104513572ma_gma
maim85831492ma_im_
maims96321792ma_ims
mama86231592ma__ma
mamma86317912ma_mma
mania75634152mani_a
manila84518302manila
maria75032882mari_a
marimba1354982marimba
marina84623412marina
maxi137023562maxi__
maxilla16248192maxilla
maximals19325222maximals
maximin1835262maximin
maximum1743572maximum
maxing164817072maxing
maxis145721562maxi_s
maxixe1435222maxixe
mazuma1935602mazuma
minima105512652minima
myxoma2043942myxoma
taximan1635782taximan
aboma91114603_aboma
agama85815583_agama
agita6315423_agita
agma77623263_a_gma
ahimsa1134783_ahimsa
aim57858213_a_im_
aims67738183_a_ims
ajiva1586803_ajiva
aliya83713483_aliya
alma66333023_a_lma
ama510853303_a__ma
amanita9310453amanita
amia66836903_ami_a
amiga85514813_amiga
amnia75918643amni_a
amrita8411133amrita
animal85016253_animal
animas84418723_animas
anime75423203_anime
animi74016663_animi
aria46245423_ari_a
aroma71220143_aroma
ataxia13179593ataxi_a
atma68121773_a_tma
axeman1538103_axeman
axial124515193_axial
axil116424453_axi_l
axile126020513_axile
axilla13289573_axilla
axils127217503_axils
axing138521373_axing
axiom143913593_axiom
axioms15408053_axioms
axion1211316913_axion
axis116127913_axi_s
axite125218253_axite
axman144813183_ax_man
baiza164813223ba_iza
bima86723833__bima
caeoma1039033caeoma
caiman103615663ca_iman
camisa103114323camisa
capita102913773capita
carina84325323carina
casita82913703casita
facia103218463faci_a
fajita1635923fajita
farina94618233farina
faxing175117053faxing
gama77035523ga__ma
gamma106116103ga_mma
haika125313793ha_ika
hakim14311833hakim_
hakims1537303hakims
halma108219253ha_lma
haniwa1236743haniwa
intima81910033intima
ixia115713213_ixi_a
jarina134014063jarina
kalimba1542663kalimba
kalmia1238893kalmia
karma113415003ka_rma
labia75219013labi_a
lama66635293la__ma
lamia75324323lami_a
lamina84920443lamina
latina65621143latina
laxity1637273laxity
lexica1536103lexica
lima65734133__lima
macing114221553macing
macula103013673macula
macumba1573043macumba
madam10316223madam_
madame1139853madame
madams11310943madams
madeira1045103madeira
madman113712383ma_dman
maffia14327203maffia
mafias113913573mafias
mafic125615463mafi_c
magi76329533magi__
magian9312833magian
magic105818653magi_c
magical1239783magical
magics115311613magics
magilp1137613magilp
magmas115512503ma_gmas
mahatma1443783mahatma
mahimahi1862803mahimahi
maid75537663ma_i_d
maids86327143ma_ids
mail65543453ma_i_l
maile75232223ma_ile
maill74420793ma_ill
mailman1137733mailman
mails76037783ma_ils
maimed114812663ma_imed
maimer104514593ma_imer
main65345523ma_i_n
mains75635113ma_ins
mair66133783ma_i_r
mairs76228303ma_irs
maist75535683ma_ist
maize164618563ma_ize
making134823853making
makuta1236393makuta
malic94525663mali_c
malice104818483malice
malign939853malign
maline84529083maline
malm85129983ma_lm_
malms95021553ma_lms
malmy124816343ma_lmy
maltha1137503maltha
mamas95930773ma__mas
mamba116317523ma_mba
mamie95826003mami_e
mamies104626243mamies
mammae94613213ma_mmae
mammal95112753ma_mmal
mammas94616403ma_mmas
mammie94313783mammie
mammy115215163ma_mmy
mana65341963ma__na
manana84816073manana
manga85026203ma_nga
maniac103917973maniac
manias84029033manias
manic94629443mani_c
manics103919933manics
manilas93915873manilas
manilla93012473manilla
manioc103914823manioc
manioca11358943manioca
manito8518693manito
manitu8315823manitu
manna75522543ma_nna
manta75629913ma_nta
mantra84116093mantra
mantua84412023mantua
maquila1844703maquila
mara67444573ma__ra
maraca10314153maraca
maremma1044463maremma
marimbas1444363marimbas
marinas93519383marinas
marine84230403marine
marish114319053marish
marital92314183marital
marka114620793ma_rka
markka11416593markka
marram10313883marram
masa65034723ma__sa
masala8311813masala
massa75518923ma_ssa
matier84321523matier
matilda1044983matilda
matin75132853mati_n
matinal9312603matinal
mating94832913mating
matins84527783matins
matza16311813ma_tza
mavie104722563mavi_e
mavies114923193mavies
mavin105722953mavi_n
mavins115119183mavins
mavis105622723mavi_s
mawing124020803mawing
max129045453max___
maxed155821193max_ed
maxes145629533max_es
maxicoat1945033maxicoat
maxillae17256723maxillae
maxillas17227703maxillas
maximally2344393maximally
maximins1944533maximins
maximise1944913maximise
maximite1955853maximite
maximize2844573maximize
maximums1842813maximums
maxixes1535253maxixes
maya95824593ma__ya
maying124421153maying
mazier175013063mazier
mazily20610393mazily
mazing184418973mazing
mazumas2034623mazumas
mbira977973m_bira
media84721713medi_a
medina94114093medina
melisma1146473melisma
miasma1097563miasma
mica86428253m__ica
milia72719573mili_a
mim76048423m__im_
mime85736403m__ime
mina65136923m__ina
minim97321603minim_
minimal114010603minimal
minimax18376013minimax
minims104514813minims
mixing164713943mixing
modica11310063modica
moira71012023m_oira
momma85111053m_omma
moxa136917743mox__a
moxie144018123moxi_e
moxies154317403moxies
myoma1239273m_yoma
myrica1336833myrica
myxomas2153913myxomas
naira5314743na_ira
optima10106533optima
oxim131114053_oxim_
oxime1498433_oxime
oxims14107643_oxims
paisa76021073pa_isa
pajama17317653pajama
panama104213353panama
patina86022193patina
pima85428653__pima
prima95019343_prima
raia46638383ra_i_a
raita54623073ra_ita
raxing144321023raxing
saiga64717933sa_iga
salina64221123salina
saliva93110743saliva
sima64730783__sima
stasima955633stasima
tafia84215493tafi_a
taiga64115663ta_iga
tarama8412733tarama
taxa116820093tax__a
taxeme1536253taxeme
taxi117124763taxi__
taxicab1843413taxicab
taxied14509373taxied
taxies135817333taxies
taximen1644923taximen
taxing143816713taxing
taxis126821973taxi_s
taxite13511303taxite
taxiway2043463taxiway
taxman15328613tax_man
ultima836313ultima
vagina102710933vagina
varia85824203vari_a
waxier16439903waxier
waxily19218413waxily
waxing174215283waxing
zamia165115213zami_a
zariba1736983zariba

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162825.92019039.9
3Display Results2822820.0962937.5
 (SQL Overall)1786912826.39227955.4
 
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.